How to number unique cells?

[Evankp]

I have an excel spreadsheet with attendees from several companies. There are several people from the same company which I want to have the same number so it would look like this:

Company # Name Company
1 Frank R&R Inc.
1 Bob R&R Inc.
1 Joe R&R Inc.
2 Sue Shop Inc.
2 Maddie Shop Inc

I want the numbers in the left column to correspond with the company name. Is there a way to do this? Thank you!

[Tony Valko]

Maybe this...

Data Range

	A	B	C
1	1	Frank	R&R Inc.
2	1	Bob	R&R Inc.
3	1	Joe	R&R Inc.
4	2	Sue	Shop Inc.
5	2	Maddie	Shop Inc.

Entered in A1 and copied down:

=SUMPRODUCT(1/COUNTIF(C$1:C1,C$1:C1))

[daddylonglegs]

Assuming you have headers in row 1 and the companies listed in groups in C2 down then try this formula in A2 copied down

=N(A1)+(C2<>C1)

[Evankp]

Thank you! This was exactly what I was looking for.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.