Extract Unique Values from Column A if Column B Contains Certain Values?
Wondering what the formula would look like to list unique values in column A, based on the values in column B.
Say in column A I have 10 students' names, and in column B I have their % grades from a test (some may be blank though).
What would the formula be to list unique values from column A, if the % in column B is 75% or higher? if there is a value at all in column B?
Thanks!
Last edited by jk2391; 10-17-2022 at 11:36 AM. Reason: Solved
maybe filter for B col >=75% then remove duplicates from A col and filter for blank
Guessing games... in the absence of a sample sheet:
=UNIQUE(FILTER(A2:A20,B2:B20>75%))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
or in the second case:
=UNIQUE(FILTER(A2:A20,B2:B20<>""))
Thank you sir - that solved it.
You're welcome. But next time, please upload a sample sheet, as per guidelines (top of page)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks