Question Locked

Excel Autonumber

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to allocate an incremental number to a cell in the Count column based on one of three options typed into the Item cell adjacent as follows:

Item Count
A 1
B 1
C 1
A 2
B 2
A 3

and so on
can anyone help?

4 replies

by 1bn0

Format | conditional formating

by locolobo

Assume your items are in range A2:A7 and the counts are in B2:B7. The formula in B2 is:

=IF(A2="A",COUNTIF($A$2:A2,"A"),IF(A2="B",COUNTIF($A$2:A2,"B"),IF(A2="C",COUNTIF($A$2:A2,"C"))))

Copy that down to B7 and it should be:

=IF(A7="A",COUNTIF($A$2:A7,"A"),IF(A7="B",COUNTIF($A$2:A7,"B"),IF(A7="C",COUNTIF($A$2:A7,"C"))))

Is that what you're trying to do?

This discussion is closed to new replies.