Unique list with additional criteria

[jasonwdillon]

Hello,

Been searching high and low for an answer to my question with little luck (hoping i didn't blindly miss it).

I have a set of data which changes each week and need to extract a unique list from it, i currently have a formula which works for me, but i now need to adapt it to include additional criteria.

Current formula: {=IFERROR(INDEX($L$3:$L$77, MATCH(0,IF(ISBLANK($L$3:$L$77),1,COUNTIF($P$3:P3, $L$3:$L$77)), 0)),"")}

I need to include the condition that the cell in column I is blank.

So basically the unique list will NOT include any entries from L if the associated cell in I is NOT blank.

A friend helped me construct the above formula, i have some excel knowledge and vaguely know functions which would work, but everywhere i seem to apply them in the formula fails to do as i hoped.

 

[jasonwdillon]

Just had chance to test it.

Thank you, works perfectly! So glad to get out of this rut!

Hiker95, don't really know much about macros, but thank you for taking the time to reply.

 

[Aladin Akyurek]

Just had chance to test it.

Thank you, works perfectly! So glad to get out of this rut!

Hiker95, don't really know much about macros, but thank you for taking the time to reply.

You are welcome.

 

[hiker95]

Hiker95, don't really know much about macros, but thank you for taking the time to reply.

jasonwdillon,

Thanks for the feedback.

You are welcome.

I am glad that Aladin Akyurek was able to solve your request.

And, come back anytime.