Home » Forums » Open Source Learning Center » Question and Answer

Compare data of 2 columns if found then remove entire row of that column and if not found then highlighted with some color

Submitted by khawar426 on 5 September, 2012 - 13:13

Hi,

I am using excel 2010 and my question is that I have data in many columns. Lets say I have to compare date of column B with Column A ,if(data of Column B) is found in Column A then delete entire row of column A.... if not found then column B highlighted with some color

‹ Substract 2 "yyyy/mm/dd hh:mm:ss" to obtain duration in "hh:mm:ss" Output Excel to Text ›
»
Nick's picture

we have this that might be of

Submitted by Nick on 6 September, 2012 - 07:29.

we have this that might be of use:
http://excelexperts.com/VBA-Tips-Compare-2-Data-Sets

»