-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
unique value count
-
V
Create list of data meeting multiple criteria
I have two issues that I am looking for help with. The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do not contain the word dog in column A on Sheet 2! The second, is that while I have calculated the...- vgresia
- Thread
- column excel & array list multiple critera unique value count
- Replies: 6
- Forum: Excel Questions
-
S
Counting unique values and it's reciprocal as one?
Hi, I'm not sure if this is possible but I am trying to count a combination of two cell values (Concatenate function) and if there are any reciprocals as one. Example: <tbody> A B C D 1 Player 1 Player 2 Combined Player Count 2 3 Bob Joe Bob&Joe...- sidt87
- Thread
- bob if$c$2$c$5= index & match joe&bob unique value count
- Replies: 3
- Forum: Excel Questions
-
D
Counting the unique values in a range.
Can someone assist with a formula that will look at column B and count the unique value for the range. for example in column B below the answer is two (2) as 25 appears at least once and 6 appears at least once. My sincere thanks in advance. <colgroup><col width="64" style="width: 48pt;"...- DSNTNOENUF
- Thread
- appears column range unique unique value count
- Replies: 3
- Forum: Excel Questions
