count duplicate data in column

My goal is to return the unique counting
How to count the number of occurrences of data that is duplicated in the column, but so to a group of duplicates has its unique sequential number.

There is 4 case,
Case1/Case3 is sorted text/values
Case2/Case4 is unsorted text/values

please you see example attach file

This formula works for all 4 of your examples

=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B12,0),MATCH(B2:B12,B2:B12,0))>0,1))

ChemistB, Thanks for answer

Maybe I misspelled topic title?
I'm sorry but this is not correct the answer for me, or I do not understand something.
This formula returns the number 4 or Unique counting numbers. I need a count for each unique data the same number

Case1

Count - Name Sorted
1 A
1 A
2 B
2 B
2 B
3 C
3 C
4 D
4 D
4 D
4 D

Case2

Count - Name UNSORTED
1 B
2 A
1 B
1 B
1 B
2 A
2 A
3 D
4 C
4 C
3 D


Please see the attachment again
I am, for each identified case enrolled the desired results

If possible without VBA?

regards

The first part of your problem: Values in A2:A12 enter in B2 and fill down:

Formula:

Please Login or Register  to view this content.

	A	B
2	A	1
3	A	1
4	B	2
5	B	2
6	B	2
7	C	3
8	C	3
9	D	4
10	D	4
11	D	4
12	D	4

This formula will solve both of the problems that you gave in msg# 3
If the data is in A2 to A12 and C2 to C12
Enter this in B2 and fill down:

Formula:

Please Login or Register  to view this content.

Enter this in C2 and fill down (same formula as above with references changed to suit new column)

Formula:

Please Login or Register  to view this content.

	A	B	C	D
2	a	1	b	1
3	a	1	a	2
4	b	2	b	1
5	b	2	b	1
6	b	2	b	1
7	c	3	a	2
8	c	3	a	2
9	d	4	d	3
10	d	4	c	4
11	d	4	c	4
12	d	4	d	3

deleted deleted

Thank you for the feedback.