I tried a1 & b1 but it will only do it for the first cell. I need to do it for the whole list.
E emiche Oct 23, 2004 #1 I tried a1 & b1 but it will only do it for the first cell. I need to do it for the whole list.
F Frank Kabel Oct 23, 2004 #2 Hi just copy this formula down. The row index will change automatically
