If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I check for duplicates in multiple sheets (in one book)?
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! |
#2
|
|||
|
|||
How do I check for duplicates in multiple sheets (in one book)?
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? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jalas" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|