| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing data in two sheets with similar values
Hello,
I have two worksheets which have similar values but are repeating. How do i compare the two and get the items which are not reconciled. Eg Sheet 1 Sheet 2 Column A Column A 50 50 100 25 25 50 50 100 100 300 25 25 100 200 I need to compare these two sheets and identify the reconciling items. I am unable to use the vlookup function because of items being repeated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing similar data on different sheet tabs | Excel Discussion (Misc queries) | |||
| comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
| Comparing Data between two sheets | Excel Worksheet Functions | |||
| Comparing sheets data | Excel Discussion (Misc queries) | |||
| Comparing data in two similar worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
