Extract Unique Value Based on Criteria

freqzz

New Member
Joined
Nov 19, 2013
Messages
9
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

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 :

ABCDE
Org CodeIdFunctionFunction CodeEmployee
654A1983A123John
655A1983A123John
656S1255C3244Carrie
657T5654E32Abraham

<tbody>
</tbody>

The formula is in another sheet

BC
FunctionA
Employee
#N/A
#N/A

<tbody>
</tbody>
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Haven't looked at your equation fully, but at least one issue is that you have reversed the arguments in the COUNTIF.
Try replacing this:

COUNTIF(Sheet2!$B$5,Data!$E$3:$E$232)
with this:,
COUNTIF(Data!$E$3:$E$232,Sheet2!$B$5)</pre>
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top