Compare and sorting Data

[shuvosdsu]

How can I compare table 1 and 2 based on column E and M and get result like table 3 and 4?

[Pete_UK]

Your post is meaningless to many contributors, who are not able to view .png files on this forum due to software compatibilities with some browsers. It is better to attach a sample Excel workbook, but if you must attach images then use jpegs or PDF files instead.

Pete

[shuvosdsu]

How can I attach excel file?

[Pete_UK]

Click on Go Advanced (below the Reply window), scroll down to and click on Manage Attachments then the Upload window will open. Click on Browse, then navigate to your file icon and double-click it, then click Upload and Close this window to get back to the Edit window. Finish off your post then click Submit.

Hope this helps.

Pete

[peterrc]

Hi,

This may not be exactly what you want but I have:-
1. replaced all your conditional formatting with one conditional format
2. sorted columms E and M by cell colour
Please see attached.
Will this work for you?

Regards

peterrc

[shuvosdsu]

I know this process but it is very time consuming as I am working with lots of worksheet.... btw... thank you.