| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and report matching numbers in two worksheets
Hi I'm still having trouble with this one. I have a column of numbers from A1 downwards. In a second worksheet , I have another lot of numbers in column A. I need a formula which will tell me which numbers in Sheet1 are also present anywhere in Sheet2 , and which aren't. Perhaps by marking 'Match' or 'No Match' against the numbers in Sheet1. Any help appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| Can't find Report Manager in XP | Excel Discussion (Misc queries) | |||
| extract matching text to make report | Excel Discussion (Misc queries) | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| Find matching records in two worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
