Hi,
Got another tough one here.. My apologies for the complex questions (at least for me it is)... As usual, permission to change title if you find a better fit for the problem.
I am in need of an index/match formula that returns a list of numbers from a data set that are GREATER THAN or LESS THAN a value, where the returned list is in ASCENDING ORDER, and is only of UNIQUE values of the data set. My biggest excel weakness is INDEX/MATCH formulas with criteria.
Please see attached spreadsheet for a sample of what I am trying to achieve. Let me know if any questions arise.
EDIT:
The solution can be multiple formulas in different columns to manipulate the data. As long as the solution is the same, I don't care what the method is. Also, if possible, please return #NA for any FALSE conditions.
Thank you very much!
Bookmarks