How do I check for duplicates in multiple sheets (in one book)?

J

jalas

All the help options give directions on how to look for duplicates within a
worksheet, but I want to check for all duplicates in all the worksheets
within one book. Please help, thanks!
 
S

Shane Devenshire

Hi,

Why don't you give us an example of what you mean. For example, if the
letter a is in A1 you want to see if the letter a is anywhere else in the
workbook? What if the letter a is in a word like "anywhere"? Do you want to
check numbers, text, dates? What do you want to do when you find them?
 

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

Access Auto Matching Duplicates? 0
Look up values in one column and compare with another 2
counting duplicates Among Many Sheets, Possible?? 5
Bar code reader for Android 1
Checking for Duplicates accross a workbook 1
Checking for Duplicates within a Workbook 7
How to copy rows from a sheet with duplicates in a column to a wor 1
Changing A "Lot Of" Data With One Command ? 2

Top