I have a multi worksheet spreadsheet and I am looking to identify if there are any duplicate entries - i.e if the same number appears more than once in any sheet, the unique number should only appear once and I want to ensure that this is true.
The column I want to search in each work sheet is column A, and I have individually named each worksheet
Hi Iain,
I'm not sure you can do this problem using Conditional Formatting as I read:
http://excelribbon.tips.net/T003433_...orksheets.html
Not using CF try this formula
=COUNTIF(Rand1,A2)+COUNTIF(Rand2,A2)+COUNTIF(Rand3,A2)
see the attached
Count Dups across multiple worksheets.xlsx
Last edited by MarvinP; 09-02-2016 at 04:43 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks