Sort unique items

[meamuka]

Hi there,

I have a table like this:

Date	Consumer	Sorting
27-Nov-17	Consum 1	1
27-Nov-17	Consum 1	2
27-Nov-17	Consum 2	1
27-Nov-17	Consum 1	3
27-Nov-17	Consum 3	1
28-Nov-17	Consum 3	1
28-Nov-17	Consum 1	1
28-Nov-17	Consum 3	2
28-Nov-17	Consum 2	1

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I would like the "Sorting" column to be automatic. I should do some sorting of unique values for each day/each customer. I don't have a clue on it. Anyone can help?

 

[Peter_SSs]

Is this, copied down, what you mean?
If not please give further explanation/examples.

Book1
	A	B	C
1	Date	Consumer	Sorting
2	27-Nov-17	Consum 1	1
3	27-Nov-17	Consum 1	2
4	27-Nov-17	Consum 2	1
5	27-Nov-17	Consum 1	3
6	27-Nov-17	Consum 3	1
7	28-Nov-17	Consum 3	1
8	28-Nov-17	Consum 1	1
9	28-Nov-17	Consum 3	2
10	28-Nov-17	Consum 2	1
Sorting

Cell Formulas
Range	Formula
C2	=COUNTIFS(A$2:A2,A2,B$2:B2,B2)

 

[meamuka]

Hi Sir,

I just tried your formula and it works. Thanks a lot and sorry for late reply.

 

[Peter_SSs]

Glad to help.