Thread: macro to compare data in column A of sheet 1 with data in column A of sheet 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default macro to compare data in column A of sheet 1 with data in column A
=if(countif(Sheet2!A:A,A1)0,"Found","")

in B1 of sheet1, then drag fill down the column. Repeat similar in sheet2.

No need for a macro.

--
Regards,
Tom Ogilvy


"nanda" wrote:

Hi Excel Experts,

Please provide me a macro which will compare data of column A in
sheet 1 with data of Column A in sheet 2 and display "FOUND" [ in
column B ] next to identical data.

thanks in advance,
nanda


Reply With QuoteReply With Quote