HolliIsAwesome
New Member
- Joined
- May 17, 2018
- Messages
- 4
Gawrsh I bombed that one. Did y'all go cross-eyed readin that title...
Mkay, so I have a spreadsheet set up that I use for scoring tests. It will automatically update each indice's numerical score for each unique corresponding name. So, often it has the same score - but because there are no duplicate names, I need to list each one.
For ex, here is a pic... in this example, there are 4 unique names for 2 sets of dups... the order that the dups are in does not matter, I just need both "77"'s to display each with their own name, and both "30"'s to display likewise.
https://drive.google.com/file/d/1H6Gq_pfRDhBdFfmnfJN1NfK0cBJOzC-0/view?usp=sharing
I've tried match, but that stops at the first finding and goes no further for me. I don't want to mess with finding a row number so the countifs or others that require a row number are not gonna work. I need a formula or formulas that are a one and done type thing.
Thank y'all *tips hat*
Mkay, so I have a spreadsheet set up that I use for scoring tests. It will automatically update each indice's numerical score for each unique corresponding name. So, often it has the same score - but because there are no duplicate names, I need to list each one.
For ex, here is a pic... in this example, there are 4 unique names for 2 sets of dups... the order that the dups are in does not matter, I just need both "77"'s to display each with their own name, and both "30"'s to display likewise.
https://drive.google.com/file/d/1H6Gq_pfRDhBdFfmnfJN1NfK0cBJOzC-0/view?usp=sharing
I've tried match, but that stops at the first finding and goes no further for me. I don't want to mess with finding a row number so the countifs or others that require a row number are not gonna work. I need a formula or formulas that are a one and done type thing.
Thank y'all *tips hat*