macro to compare data in column A of sheet 1 with data in column A of sheet 2
 

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

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

macro to compare data in column A of sheet 1 with data in column A
 

On Nov 5, 10:43 pm, Tom Ogilvy
wrote:
=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- Hide quoted text -

- Show quoted text -

Thanks so much, it solved my issue, I appreciate your time.

Nanda