Ascending count of same items in a column containing multiple items

Hi guys i'm working on a formula that i can't seem to solve. I'm currently trying to count similar items in a list which contains multiple items. I have attached a sample and hopefully someone has encountered the same already. Basically column "A" contains the list of items that i have and column "B" will contain the ascending count of the items regardless of any order in column "A".

Hi there,

Try this: =COUNTIF($A$2:A2,A2)

...and drag down.

HTH,

SamuelT

Originally Posted by SamuelT

Hi there,

Try this: =COUNTIF($A$2:A2,A2)

...and drag down.

HTH,

SamuelT

Hey thanks for the reply! The formula works just fine! =)

Cheers!

Kelvi43