Unique Filter

rhombus4

Well-known Member
Joined
May 26, 2010
Messages
586
Office Version
  1. 365
  2. 2016
Platform
  1. 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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
Not sure I understand the question. If you just want to show the distinct values from col A change A:B to A:A
 
Upvote 0
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
 
Upvote 0
No problem. I'll have to wait for access to pc. To show some data
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top