Lookup with multiple results, without duplicates
Or using Advanced Filter
Num1 Num2
56 5
100 7
46 7
46 7
88 7
100 7
75 8
Criteria
Test
FALSE
Num1
100
46
88
I assume you already applied the names Num1, Num2
Select Num1 and its data cells (8 cells) and give it the name Database.
Select Test and False (2 cells) and give it the name Criteria.
In the cell that says FALSE, enter this formula:
=OFFSET(Num1,,1,1)=7
Data Filter Advanced Filter
Click on Copy to another location
Click on Unique records only
Fill in Copy to
List range and Criteria range have been filled automatically.
|