Hi
I have a huge dataset displayed in column format, ie each field is in columns. I need to do a look to match 2 columns and then once I found those rows, I want to find the minimum within those rows.
Ie say I need to find the minimum sales data for green apples.
Then I need check column A...