Hi,
I have a excel will below data, it will identify the set of repeated numbers and seperate a line on each set. That is working fine so far, but i need to add one more Inputbox and allow user enter the column to check for duplicates.
So that i will check for duplicates in each set and highlight with color and add text "duplicate" at last column.
Data:
13 D29
13 D29
13 D3
14 D3
14 D85
15 D78
15 D78
15 D78
It will identify 13 as on set and add a new empty line and similar to 14 and 15 as below.
13 D29
13 D29
13 D3
14 D3
14 D85
15 D78
15 D78
15 D78
Now it has to identify duplicates in each set and highlight and add duplicate text.
13 D29
13 D29 Duplicate
13 D3
14 D3
14 D85
15 D78
15 D78 Duplicate
15 D78 Duplicate
Below is the code i tried..
I am not able to identify duplicates and highlight. Can someone please help..?Please Login or Register to view this content.
Thanks
Sanjay
Bookmarks