Hi everyone,
Great if anyone can help with this. I have two sheets,
1) Data - Contains data of pupil from different countries in different age groups with their unique IDs
2) Condition - Contains different combination of countries and age group
Expected output - Looking to filter "data" sheet based on the criteria in "Condition" sheet and predict the matching unique IDs for different condition
Test workbook
P.S. I have to this on over 150K rows and would only need 5 matching IDs for every test.
Any help will be greatly appreciated
Thanks
Kane
Great if anyone can help with this. I have two sheets,
1) Data - Contains data of pupil from different countries in different age groups with their unique IDs
2) Condition - Contains different combination of countries and age group
Expected output - Looking to filter "data" sheet based on the criteria in "Condition" sheet and predict the matching unique IDs for different condition
Test workbook
P.S. I have to this on over 150K rows and would only need 5 matching IDs for every test.
Any help will be greatly appreciated
Thanks
Kane