I have data in column A at random intervals. I'd like to auto-increment
a number in Column B only if data appears in column A in the same row.

So:

__ A | B
1 aa | 01
2
3 bb | 02
4 cc | 03
5
6
7
8 dd | 04
9
10


etc

Then, if data were added to any row in column A, the numbers in B would
all update.

Anyone have a simple solution?


--
alexmace
------------------------------------------------------------------------
alexmace's Profile: http://www.excelforum.com/member.php...o&userid=32325
View this thread: http://www.excelforum.com/showthread...hreadid=520831