Hi Gurus,
I need a help on getting my formula correct. I am trying to extract unique in a list, copy it to another sheet based on criteria.
The formula im using is
I followed the instruction and link it accordingly but it doesnt work.
Can you please point me to the right direction?
Here is the table :
<tbody>
</tbody>
The formula is in another sheet
<tbody>
</tbody>
I need a help on getting my formula correct. I am trying to extract unique in a list, copy it to another sheet based on criteria.
The formula im using is
Code:
=INDEX(Data!$E$3:$E$232,MATCH(0,COUNTIF(Sheet2!$B$5,Data!$E$3:$E$232)+(Data!$C$3:$C$232<>Sheet2!$C$3),0), COLUMN(Data!E2))
I followed the instruction and link it accordingly but it doesnt work.
Can you please point me to the right direction?
Here is the table :
A | B | C | D | E |
Org Code | Id | Function | Function Code | Employee |
654 | A1983 | A | 123 | John |
655 | A1983 | A | 123 | John |
656 | S1255 | C | 3244 | Carrie |
657 | T5654 | E | 32 | Abraham |
<tbody>
</tbody>
The formula is in another sheet
B | C |
Function | A |
Employee | |
#N/A | |
#N/A |
<tbody>
</tbody>