Formula for Repeated Names.

Hi friends,

As per below table I want formula like

ABC came first time, then "1"
ABC came second time, then "2"
ABC came thrid time, then "3"

Same rule for other companies.

Thank you Friends,

Thank you Richard

Elaborating on what Richard posted. If you have any blank cells try this:

Please Login or Register  to view this content.

Assuming you have column headers to start data at row 2.

Thank you,

How can I get like 001, 002

Thank you,

How can I get like 001, 002

try:

Formula:

Please Login or Register  to view this content.

Or ...

=TEXT(COUNTIF(A$1:A2,A2),"000")

Thank you,

How can I get like 001, 002

I am using below formula

Please Login or Register  to view this content.

Result : RG / BB / 1 / 17

I want / 001 /, instead of / 1 /

OK GOT IT

Please Login or Register  to view this content.

=iferror(base(countif($em$9:$em9,em9),10,3),"")

OK GOT IT

Please Login or Register  to view this content.

If your problem is resolved , click on reputation star to person(s) who helpd you and mark thread as solved. Thank you