Comparing Cells in a row, Columns (> than 10) and checking if adjacent cells have same cell value

[Alvin187]

Hi all,

Problem: My maximum Range is around 10000 Rows x 365 columns, I want to compare cell values across a row .
Conditions: It has to return how many times a name is repeated in each row for every primary key
if a name comes only once in a row, that need not be shown, anything more than 2 should be displayed
It has to exclude blank cells and if it encounters "Dispatched" then it need not count further.
Requirement: Any solution either excel or macro would do.

PFB Sample excel sheet.

The Output for the same should be
20/F/43352/2 - Filing - 3days, Final Polish - 3 days
20/F/43352/2 - Filing - 3days, Final Polish - 3 days
20/F/43352/2 - Filing - 3days, Final Polish - 3 days

[TABLE]
[TR]
[TD]Bag Number[/TD]
[TD]8th July[/TD]
[TD]9th July[/TD]
[TD]10th July[/TD]
[TD]11th July[/TD]
[TD]12th July[/TD]
[TD]13th July[/TD]
[/TR]
[TR]
[TD]20/F/43352/2[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/3[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/4[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/5[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/6[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/7[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/8[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[TR]
[TD]20/F/43352/9[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FILING[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[TD]FINAL POLISH[/TD]
[/TR]
[/TABLE]

 

[Alvin187]

Bag No	8th July	9th July	10th July	11th July	12th July	13th July
20/F/43347/1	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/2	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/3	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/4	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/5	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/6	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH
20/F/43347/7	FILING	FILING	FILING	FINAL POLISH	FINAL POLISH	FINAL POLISH

this is the excel file.


The Output for the same should be
20/F/43347/1 - Filing - 3days, Final Polish - 3 days
20/F/43347/2 - Filing - 3days, Final Polish - 3 days
20/F/43347/3 - Filing - 3days, Final Polish - 3 days