I've seen formulas that can extract unique values from a row or column, like
{=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"")}
but I can't make this work for a range of cells, like this:
<tbody>
</tbody>Where the data in A1:C4 is extracted to show only unique values of G3:N3.
Ideally, I'd also like to have the results sorted, too.
I won't be supporting this spreadsheet, so I would prefer not to use VBA to do this.
Thanks!
{=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"")}
but I can't make this work for a range of cells, like this:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | Bob | Alice | David | |||||||||||
2 | Mark | Alice | Nancy | |||||||||||
3 | George | Sandy | Karen | Alice | Bob | David | George | Karen | Mark | Nancy | Sandy | |||
4 | Karen | Nancy | Bob | |||||||||||
5 |
<tbody>
</tbody>
Ideally, I'd also like to have the results sorted, too.
I won't be supporting this spreadsheet, so I would prefer not to use VBA to do this.
Thanks!