Need help with counting duplicates in another row

Hi,

I am not sure if this is the right category for my thread as I am a complete newbie with Excel...

I have a list of my customers in Excel, "Order List".. The problem is I want to know how many times they have ordered.

I have attached the image

Screenshot 2.JPG

And as you can see I have a list like that.. The list is very big around 23,000 records. The Unique records should be around 9500+

What I need help is

For example: If "Alex" has ordered 5 times.. I need number "5" next to Alex row... and the rest 4 duplicates should be deleted.

So I just need one unique row with number of orders in next row..

Is it possible? or I have to go through manually?

Please help!

Originally Posted by AkbarPasha

And as you can see I have a list like that..

Actually, many of us can't see *.png images.

If you're going to post an image try it as a *.jpg image.

However, it might be a better idea to post a SMALL sample file instead. SMALL = about 20 rows worth of data. Make sure you tell us what result you expect.

Something like this...

Data Range

	A	B
1	------	------
2	Name 1	4
3	Name 1
4	Name 1
5	Name 1
6	Name 2	1
7	Name 3	4
8	Name 3
9	Name 3
10	Name 3
11	Name 4	2
12	Name 4
13	Name 5	3
14	Name 5
15	Name 5

This formula entered in B2 and copied down as needed:

=IF(A2=A1,"",COUNTIF(A:A,A2))

Then, convert the formulas to constant values...

Select the entire range of formulas
Right click>Copy
Right click>Paste Special>Values>OK

Then you can delete the rows without a count value in column B.

You can probably filter for blanks in column B then delete those rows.

Maybe use this formula instead:

=IF(A2=A1,"",COUNTIF(A:A,A2)-1)

You're welcome. Thanks for the feedback!