Auto number count up but for same value not count

[sophea_tum]

Hi,

I am wonder how can i get the result as in "Auto Number" column:

A title	B Title	C Title	D Date	Auto Number
A1	B1	Yes	28-Jun-18	1
A1	B1	Yes	28-Jun-18	1
A1	B2	No	22-Jul-18	1
A1	B1	Yes	23-Jul-18	2
A4	B4	Yes	20-Aug-18	1
A5	B3	Yes	23-Aug-18	1
A5	B3	Yes	1-Sep-18	2
A6	B6	Yes	3-Sep-18	1

<tbody>
</tbody>

When A, B C D column is the same value, it count only 1, but when A, B C same but D different it will count one more over the A,B,C that with same value.

Sorry it is difficult to explain but please look the table above than we will understand that result that I want.

Please help me!!! I am stuck with that!

thanks,
Sophea.

 

[Jeffrey Mahoney]

Please try this:

in cell E2 put:
=IF(COUNTIFS($A$1:$A4,A5,$B$1:$B4,B5,$C$1:$C4,C5,$D$1:$D4,D5)>0,1,MAXIFS($E$1:$E4,$A$1:$A4,A5,$B$1:$B4,B5,$C$1:$C4,C5)+1)

Copy the formula down.

This assumes you have the table starting in cell A1