Count unique over multiple sheets.
I am trying to count the number of unique entries in a column over multiple sheets. For example...
SHEET 1
Apple
Banana
Pear
SHEET 2
Apple
Apple
Apple
SHEET 3
Banana
Cheeseburger
Pear
The count I'm looking to get would be 4 beause there are 4 total unique items - Apple, Banana, Pear, Cheeseburger.
Thanks!
Firstly define sheet name.
in summary sheet in "F2"Formula:
Please Login or Register to view this content.
"E2" is criteria.
see attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
A bit different approach as I use a macro to find the unique values. To test click macro button "Run Macro" on "Summary" sheet. I've also added more items to the different sheets to test the range setting.
Alf
Last edited by Alf; 08-05-2018 at 09:34 AM.
Here's a formula that "works".
Unfortunately I was unable to come up with something shorter or simpler. I had to settle for atrocious.LOL
It is array entered. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
Dave
Ah! Managed to trim that previous formula down a bit ... from 4 and half lines to 2 and a third. Still array entered.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks