how do i look through worksheets in a workbook to find duplicate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 worksheets in a workbook. I need a formula that will look through
the worksheet for duplicated information and display in another worksheet.
 
Hi Connie,

I regularly use the COUNTIF function, providing you have a unique
identifier, which counts the number of the cells in a range with the
value which you state (which can be a value or cell). Any entries that
are NOT duplicated will return 1, because only one instance has been
found, and any entries that are duplicated (or more) will return the
number of times they are in the range.

=COUNTIF(Range,Criteria)

Good luck,


Roly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
finding duplicate addresses across 2 worksheets in the same workbo 2
Compare data (2 columns) from 2 worksheets within a workbook 2
Duplication 1
Checking for Duplicates within a Workbook 7
linking worksheets to a closed workbook 2
want to create a link to another worksheet in another workbook 1

Back
Top