Johnny4strings
New Member
- Joined
- Nov 9, 2018
- Messages
- 33
Hello everyone,
I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count off.
Here is a mockup of the output:
<tbody>
</tbody>
I would like to make a formula that would count the instances-focusing on the differences in columns I and K.
For example, I am just interested that "tom bailey" "2/0" appears on my list one time, not how many times that it did; ideally I would like a formula that gave me a value of 2 for both instances of tom bailey and for one for the ann wilson instance (I want to count combinations concerning name and rank).
The formula must count the distinct instances of name (col I) and rank (col K). This is puzzling me as I know how to author a countif, however I do not want to disregard the repeated count of each and every instance of "tom bailey" "2/0" as this output is actually thousands-not just three rows.
I appreciate any help you all may be willing to provide!
John
I am currently working with a large amount of data from an output. I am trying to make a formula that only counts one instance of a repeated value. Basically, and I am trying to make a head count based upon name and rank and I am getting repeated information throwing my count off.
Here is a mockup of the output:
| A | B | C | D | E | F | G | H | I | J | K |
| 99 | 2018 | 2019 | 2/1/2018 | 100 | 100 | GUST | F | TOM BAILEY | MANAGER | 2/0 |
| 99 | 2018 | 2019 | 2/1/2018 | 100 | 100 | GUST | F | TOM BAILEY | MANAGER | 2/0 |
| 99 | 2018 | 2019 | 2/1/2018 | 100 | 100 | GUST | F | ANN WILSON | SECRETARY | 2/0 |
<tbody>
</tbody>
I would like to make a formula that would count the instances-focusing on the differences in columns I and K.
For example, I am just interested that "tom bailey" "2/0" appears on my list one time, not how many times that it did; ideally I would like a formula that gave me a value of 2 for both instances of tom bailey and for one for the ann wilson instance (I want to count combinations concerning name and rank).
The formula must count the distinct instances of name (col I) and rank (col K). This is puzzling me as I know how to author a countif, however I do not want to disregard the repeated count of each and every instance of "tom bailey" "2/0" as this output is actually thousands-not just three rows.
I appreciate any help you all may be willing to provide!
John
