How to search an array for the smallest value then display another column, while removing duplicates
I am trying to create a formula to search two columns of data, find the smallest value, and return the value that corresponds to that specific column, while removing duplicates.
Essentially, 'Lab List A' and 'Lab List B' are the two columns I want to sort by order, while removing duplicates. I created the extra columns in an attempt to shorten the equation. 'Lab List A' and 'Lab List B' are two different lists of labs that have duplicates and also some labs with letters at the end of the string. Everything I've tried so far only returns the values in 'Lab List A' and I think it's because I haven't solidified a concrete way of determining if the lab of interest is already included in the 'Lab Location' column. The 'LL' and 'Both Presence' columns are unnecessary for now. If you need any other information please let me know.
Help Article Resources
Check out the Formula Handbook template!