Cant work this out.
4kiqIHh.png
https://i.imgur.com/4kiqIHh.jpg
I've got those formulas in two different sheets. How can I get a count of the unique values in both ranges in a single cell? i.e the count of those shown in yellow?
EDIT: 1003 and 1007 should be highlighted yellow in the second range as well.Book1.xlsx
Last edited by akbermo; 11-18-2015 at 06:49 AM. Reason: uploaded workbook
Hi and welcome to the forum,
You're likely to get a better response if you upload the actual workbook rather than a picture. Not many of us are inclined to recreate your data when you already have it. - See also recommendations in the rules area.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks, uploaded
Hi,
Why is 1003,x,b unique when 1004,y,a isn't?
I need to understand how you are defining unique.
Unique values that meet the specified condition. I would be counting those others as well using the same formula in a different cell.
In the example given I am interested in unique values in the separate columns that meet condition "x" and "b".
"y" and "a" would be counted in a separate cell.
Hope that makes sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks