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:

<tbody>
[TD="class: xl65"]A title[/TD]
[TD="class: xl66"]B Title[/TD]
[TD="class: xl68"]C Title[/TD]
[TD="class: xl67, width: 112"]D Date[/TD]
[TD="class: xl68, width: 90"] Auto Number
[/TD]

[TD="class: xl69, width: 69, align: left"] A1
[/TD]
[TD="class: xl70, width: 82, align: left"] B1 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 28-Jun-18 [/TD]
[TD="class: xl72, width: 90"] 1 [/TD]

[TD="class: xl69, width: 69, align: left"] A1
[/TD]
[TD="class: xl70, width: 82, align: left"] B1 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 28-Jun-18 [/TD]
[TD="class: xl72, width: 90"] 1 [/TD]

[TD="class: xl69, width: 69, align: left"]A1[/TD]
[TD="class: xl70, width: 82, align: left"]B2[/TD]
[TD="class: xl70, width: 88, align: left"] No
[/TD]
[TD="class: xl71, width: 112"] 22-Jul-18
[/TD]
[TD="class: xl72, width: 90"] 1
[/TD]

[TD="class: xl69, width: 69, align: left"] A1
[/TD]
[TD="class: xl70, width: 82, align: left"] B1 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 23-Jul-18 [/TD]
[TD="class: xl72, width: 90"] 2 [/TD]

[TD="class: xl69, width: 69, align: left"] A4
[/TD]
[TD="class: xl70, width: 82, align: left"] B4 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 20-Aug-18
[/TD]
[TD="class: xl72, width: 90"] 1
[/TD]

[TD="class: xl69, width: 69, align: left"] A5
[/TD]
[TD="class: xl70, width: 82, align: left"] B3 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 23-Aug-18
[/TD]
[TD="class: xl72, width: 90"] 1 [/TD]

[TD="class: xl69, width: 69, align: left"] A5
[/TD]
[TD="class: xl70, width: 82, align: left"] B3 [/TD]
[TD="class: xl70, width: 88, align: left"] Yes [/TD]
[TD="class: xl71, width: 112"] 1-Sep-18 [/TD]
[TD="class: xl72, width: 90"] 2 [/TD]

[TD="class: xl69, width: 69, align: left"]A6[/TD]
[TD="class: xl70, width: 82, align: left"] B6
[/TD]
[TD="class: xl70, width: 88, align: left"] Yes
[/TD]
[TD="class: xl71, width: 112"] 3-Sep-18 [/TD]
[TD="class: xl72, width: 90"] 1
[/TD]

</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