Eternal-Mercury
asked on
Excel Formula, counters based on another cell's contents, continuous.
Excel Spreadsheet.
Column F and G.
Column F lists names of objects. A, B, C, D, etc.
Column G is a counter column for objects that begin with "A".
F1 = A
F2 = A
F3 = A
F4 = A
F5 = B
F6 = A
F7 = C
F8 = C
F9 = A
I want the G column to count but I don't know how to make the formula...
Result should be...
G1 = 1
G2 = 2
G3 = 3
G4 = 4
G5 = 4
G6 = 5
G7 = 5
G8 = 5
G9 = 6
I have no idea how to create formula @.@.
Column F and G.
Column F lists names of objects. A, B, C, D, etc.
Column G is a counter column for objects that begin with "A".
F1 = A
F2 = A
F3 = A
F4 = A
F5 = B
F6 = A
F7 = C
F8 = C
F9 = A
I want the G column to count but I don't know how to make the formula...
Result should be...
G1 = 1
G2 = 2
G3 = 3
G4 = 4
G5 = 4
G6 = 5
G7 = 5
G8 = 5
G9 = 6
I have no idea how to create formula @.@.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
usarian,
Please check other responses before posting a comment.
Wayne
Please check other responses before posting a comment.
Wayne
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys.
=COUNTIF($F$1:F1,"A")
then copy it down the column.