Sl No

[sambit]

Sir,

Please help to resolve the issue.

If row data is same, then sl no should be continue (1,2,3......). Otherwise it must be one.

Please find example file.

 

[Hui]

add a Helper Column
G5: =D5&E5&F5
Copy that down
H5: =COUNTIF($G$5:G5,G5)
Copy H5 down

Enjoy

 

[GraH - Guido]

Perhaps this little improvement in the helper column of Hui's solution is required to avoid potential issues when data is like C - 45 - 750. It will count as 3 while it is different from C - 457 - 50.

G5: =D5&"-"&E5&"-"&F5

 

[sambit]

Hui Sir,
Many many thanks.

 

[bosco_yip]

Or use this without helper

In H5, copied down :

=COUNTIFS(D$5:D5,D$5:D5,E$5:E5,E$5:E5,F$5:F5,F$5:F5)

Regards
Bosco

 

[sambit]

Bosco_yip Sir,

Excellent.

can you explain the logic behind the formula?

 

[GraH - Guido]

Or use this without helper

In H5, copied down :

=COUNTIFS(D$5:D5,D$5:D5,E$5:E5,E$5:E5,F$5:F5,F$5:F5)

Regards
Bosco

Oh my, indeed!!!!

 

[bosco_yip]

Bosco_yip Sir,

Excellent.

can you explain the logic behind the formula?

The multi-criteria Countifs formula logic is equal to Hui's helper solution
in Post #.2

Regards
Bosco