I have 5 columns of data imported from another program into excel. I want
the 1st column to be numbered in sequential order based on input from the 4th
column. If cell D1 has text in it then cell A1 should read the number 1. If
cell D2 is empty the A2 should be empty. If cell D3 has text in it then A3
should read number 2. The forth column will always change based on the
imported data and I want the first column to reflect that. Any ideas?
--
wsk