| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
| Column Data to Appear as Column Headings in Another Sheet | Excel Discussion (Misc queries) | |||
| Add data to sheet, in next available column. | Excel Programming | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
| Compare Sheet Cell to Sheet Column | Excel Worksheet Functions | |||
Linear Mode
