*see attached spreadsheet for data
Trying to create in "Summary" sheet a list of all information[numbers] when information[comparision of cells] matches one of the "results meaning" sheet lists (either light or heavy results) no duplicates required.
I know I need an array, tried using INDEX and MATCH functions in an array with ROW but I don't understand it enough to use it properly and it produced different values. to what I needed.
Bookmarks