Counting numbers

[dmiller223]

I am new to Mr. Excel and Excel in general. I am creating a spreadsheet where in column A I need to number the items from 1-500, but I only want the next number to populate based on a date being entered in B.

For example,

A5 would have the number 1 in it only after B5 had a date entered. Then A6 would have the number 2 only after B6 had a date entered. If anyone could help, I would greatly appreciate it.

Thanks again.

 

[Marcelo Branco]

Hi,

Welcome to the forum.

Try this in A5
=IF(ISNUMBER(B5),ROWS($A$5:A5),"")

copy down till you need

HTH

M.

 

[crusader]

I am new to Mr. Excel and Excel in general. I am creating a spreadsheet where in column A I need to number the items from 1-500, but I only want the next number to populate based on a date being entered in B.

For example,

A5 would have the number 1 in it only after B5 had a date entered. Then A6 would have the number 2 only after B6 had a date entered. If anyone could help, I would greatly appreciate it.

Thanks again.

Assuming A5 already has the value of one, enter the following in A6 and copy down as needed:

=IF(NOT(ISBLANK(B6)),A5+1,"")

 

[dmiller223]

Thank you both for the quick reply. I am going to use this group from now on. You took the 3 hours of searchin online into about five minutes worth of work. Thank you very much again.