rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Hi I want to filter column A:B where A Isn't Blank AND column D is Blank
I have
=Unique(filter(a:b,(a:a<>"")*(d:d="")))
But same values in column A appear more than once with formula above
I.e. dog appears in A2 a8 and a9 and d8 and d9 are blank but In formula dog appears twice.
Seems unique is based on column a and b. I only want it unique on column a
I have
=Unique(filter(a:b,(a:a<>"")*(d:d="")))
But same values in column A appear more than once with formula above
I.e. dog appears in A2 a8 and a9 and d8 and d9 are blank but In formula dog appears twice.
Seems unique is based on column a and b. I only want it unique on column a