![]() |
comparing two cols and placing blanks.
How do we do this in excel
the sheet looks like this col1 col2 col3 col4 col5 abc a1 abc 123 a1 xyz z1 abc 345 a1 xyz 789 z1 The output that I want is col1 col2 col3 col4 col5 abc a1 abc 123 a1 abc 345 a1 xyz z1 xyz 789 z1 I am matching the col2 and col5 and when they dont match i am placing blank row. I'd appreciate help with this Feroz |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com