Hi All
I need to extract unique values based on specific criteria to use for other procedure ,
for example, for the chart below (illustration only, not actual data), I would need to extract the string (A,C)
List
<tbody>
</tbody>
Currently I have no idea how should I tell excel to do both:
1) extract only Unique values to an array (i.e. examples above I only want "A,C" not "A,C,C")
2) fill values to an array based on criteria from adjacent column
any help is appreciated
Thanks
I need to extract unique values based on specific criteria to use for other procedure ,
for example, for the chart below (illustration only, not actual data), I would need to extract the string (A,C)
List
Criteria | |
A | 0 |
A | 0 |
A | 1 |
B | 0 |
B | 0 |
C | 1 |
C | 1 |
<tbody>
</tbody>
Currently I have no idea how should I tell excel to do both:
1) extract only Unique values to an array (i.e. examples above I only want "A,C" not "A,C,C")
2) fill values to an array based on criteria from adjacent column
any help is appreciated
Thanks