![]() |
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. |
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. |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com