Hi all,
I was wondering if I could please seek your advice on the following problem:
The attached worksheet contains an extract of data from a large dataset. I would like to return the 'GROUP' and 'Sampling Method' for the Nth smallest 'Total QA cost'. In this case N = 1. As it stands, the forumla in F26 and F27 return the Nth smallest value.
However, I would now like to understand how to exclude rows where the 'Includes ON-LINE analysis' contains an N. I've tried adding an AND function to the IF but this did not work. Does anyone have any good ideas?
Thanks in advance!
Bookmarks