Unique Filter

[rhombus4]

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

 

[Fluff]

Seems unique is based on column a and b

Yes it is.

I only want it unique on column a

In that case which of the two values should be returned for col B?

 

[rhombus4]

Oops just realised question doesn't make sense lol. It has to show duplicates unless values in B are the same.

I asked chatgpt and it spouted out some crap that froze and crashed pc

PS should only appear once as whichever value appears in Column A the value in column be would be the same i.e. dog B would be 1
Cat B would be 2, zebra B would be 3 etc

Would have posted more details but pc is at work so using phone to post.

Actual question was to only Show Values in Column A Where D is Blank, But only Show where all duplicated values in A And corresponding Row in D is Blank

 

[Fluff]

I'm afraid that makes even less sense.
If col B will always be the same value where col A is Dog, then the formula you posted should work.

 

[rhombus4]

It did work. It was when testing with different values that I got the extra dogs

Realised after your post that it didn't make sense.

regarding the actual question in post #3 shall I post that in new thread

 

[Fluff]

Not sure I understand the question. If you just want to show the distinct values from col A change A:B to A:A

 

[rhombus4]

I wanted to show values in A and B which my initial formula did.

The actual full question was only Show Values in Column A Where D is Blank, But only Show where all duplicated values in A And corresponding Row in D is Blank

 

[Fluff]

I'm afraid I don't understand what you mean by

only Show where all duplicated values in A And corresponding Row in D is Blank

 

[rhombus4]

No problem. I'll have to wait for access to pc. To show some data

 

[Fluff]

Ok