| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing sheets data
How do i compare two (or three) sheets to find wich cells are duplicating?
I want to compare two sheets and find out which numbers are duplicating (same). And is it possible to get an answer in a new worksheet? Thanks. |
|
#2
|
|||
|
|||
|
Hi,
Are you familiar with lookup functions? VLOOKUP, HLOOKUP, INDEX. Before I can suggest one I would need to have a description of how the data is presented in the worksheets. Regards, Jon "Vytautas" wrote: How do i compare two (or three) sheets to find wich cells are duplicating? I want to compare two sheets and find out which numbers are duplicating (same). And is it possible to get an answer in a new worksheet? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To data apearing in other sheets I can use =SUM(. How I can have . | Excel Worksheet Functions | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Linear Mode
