Index and Match function

[Geo Jul]

Dear All,
I am facing a problem with this formula I usually use this formula: =INDEX($B$2:$B$127,MATCH(0,COUNTIF($J$15:J15,$B$2:$B$127),0),1)
to extract non-duplicate items from a list, know that some cells are empty so it won't work
Your assistance in this subject is highly appreciated

Regards

 

[Geo Jul]

Please post some sample data & expected results.

Thank you

 

[Geo Jul]

Please post some sample data & expected results.

thank you

 

[smozgur]

Many thanks for your solution and your time

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.