Thread: Creating a New Unique

Hi,
I'm trying to create a unique list, where if an item is True, it will appear on the list. I'm using long IF statements, but what ends up happening is that I get duplicates...I understand why that's happening, but can't seem to come up w/ a solution. Any help would be truly and greatly appreciated.

Thanks!

I've attached my file here.

Unique List.xlsx

Hello
You could try using Array Formulas. These are entered with Ctrl+Shift+Enter. See attachment.

Hope this helps.