number columns skip blanks
 

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

number columns skip blanks
 

In A1, enter formula:
=IF(D1="";"";ROW())
and copy down.

HTH
--
AP

"wsk" a écrit dans le message de news:
...
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

number columns skip blanks
 

Try this:

A1: =IF(ISBLANK($D1),"",COUNTA($D$1:$D1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"wsk" wrote:

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

number columns skip blanks
 

=IF(ISBLANK(D1),ROW(),"")
Put this in A1 and fill down as necessary!

Regards,
Stefi


€žwsk€� ezt Ã*rta:

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

number columns skip blanks
 

Ron, Worked great thank you ! Thank all of you for responding!!!!
--
wsk


"Ron Coderre" wrote:

Try this:

A1: =IF(ISBLANK($D1),"",COUNTA($D$1:$D1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"wsk" wrote:

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