Finding the lowest 2 values across two rows, return row headers

Originally Posted by zbor

I'ts not clear: can 2 minimum values be in one row? For example if B10 is -14.5 do you expect to return ST and AP or minimum from each row?

Hi zbor,

Yes, the minumum values could exist within the same row. In my example I have it split across row 5 and row 10, but it may be that when you inspect row 5 and row 10 together then the minimum values are only found in 1 of the rows.

Where the mimimum value is found I would like to go directly to the row header for that data set. In this instance, if both minimum values are found in row 10 then it would return 2 header values (called category) from row 6. If a minimum value was in row 5 and the 2nd minimum value in row 10 then I would like it to return the header from row 1 and row 6 respectively.

Appreciate the help!

-- Edit --

I see what you have done there and that was how I initially had it, until I realised the minimum values may exists in the same row but I need to check both rows before I can identify if that is the case.

Ronan