•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Criteria within FILTER for UNIQUE results based on a certain range.
Our take
To enhance your current FILTER formula and ensure unique results based on course numbers, you can combine the FILTER function with the UNIQUE function. Start by applying the FILTER criteria as you have, and then wrap it with UNIQUE to eliminate duplicates. Here’s a revised formula:
`=UNIQUE(FILTER(Grades!A:A, (Grades!D:D>=80)*(Grades!B:B=6)*(LEFT(Grades!F:F)="S")*(Grades!G:G<>"08320005")))`
This approach will give you distinct entries for each course number while maintaining your original filtering criteria.
Here is my current formula:
=FILTER(Grades!A:A,(Grades!D:D>=80)*(Grades!B:B=6)*(LEFT(Grades!F:F)="S")*(Grades!G:G<>"08320005"))
This works wonderfully to pull out the information that I need with one potential issue. It will duplicate a result from the same course in different terms. The course numbers are in Grades!G:G, and the term ID's are in Grades!F:F. What criteria can I add to this FILTER that would yield results only one time if a course number in Grades!G:G is repeatedly matching the other criteria?
I have used UNIQUE for this when I need the result of the FILTER to be UNIQUE, but I am not having luck with making a criteria look for uniques.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#rows.com#AI formula generation techniques#Excel compatibility#real-time data collaboration#real-time collaboration#formula generator#Excel alternatives#cloud-based spreadsheet applications#FILTER#UNIQUE#Grades#course number#criteria#duplicates#terms#results