Unique List Issue

PHIL.Pearce84

Board Regular
Joined
May 16, 2011
Messages
152
Office Version
  1. 365
Platform
  1. Windows
Afternoon,

I am using the following formula to create a unique list, typically I wont have a fixed reference point at the point B10 is reference and the formula works fine in these instances. However in this case B10 will be come B11 and so forth, the issue I'm having is the formula is creating a unique list of numbers but ignoring the fact that although the number is already list in column B it is not unique when you factor in the number referenced in B10.

I.E B10 has a number 1234 and C10 has returned the value of 1, however when it looks at B11 which has a value of 4567 it does not return the 1 that is unique based on both criteria but instead returns blank.

Can anyone help, I apologise if this is very clear.


{=IFERROR(INDEX('Source Data'!$N$2:$N$5000,MATCH(0,IF(B10='Source Data'!$M$2:$M$5500,COUNTIF($D$2:$D9,'Source Data'!$N$2:$N$5000),""),0)),"")}
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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