Hello all,
I have a formula I have worked out that needs one more item.
It pulls only unique values from a list. I want it to also display on the list from that column the Sample IDs that show up with a C to start their ID. The list contains other information I do not want in this list.
Here is the formula below. It goes in the column that displays the results.
Any help of how to modify, thanks in advance.
DThib
I have a formula I have worked out that needs one more item.
It pulls only unique values from a list. I want it to also display on the list from that column the Sample IDs that show up with a C to start their ID. The list contains other information I do not want in this list.
Here is the formula below. It goes in the column that displays the results.
Code:
=IFERROR(INDEX('Run Data'!$B$18:$B$5000,MATCH(0, FREQUENCY(IF(EXACT('Run Data'!$B$18:$B$5000,TRANSPOSE($A$2:A2)), MATCH(ROW('Run Data'!$B$18:$B$5000),ROW('Run Data'!$B$18:$B$5000)), ""), MATCH(ROW('Run Data'!$B$18:$B$5000),ROW('Run Data'!$B$18:$B$5000))), 0)), "")Any help of how to modify, thanks in advance.
DThib
