cansevin
asked on
Count How Many Times number appears
Column B is a list of number - representing Contact ID's. Some appear once, twice, three time or manybe even 4
In Column A, I want a 1 if it is the 1st time the number appears, a 2 if it is the 2nd time the number appears... and so on.
Is there a formula that will do this? Thank you!
In Column A, I want a 1 if it is the 1st time the number appears, a 2 if it is the 2nd time the number appears... and so on.
Is there a formula that will do this? Thank you!
ASKER
Ok... How? My understanding was countif only gives you the total. So they all would be the highest number.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.techonthenet.com/excel/formulas/countif.php