( by tic toc )
I would like to be able to copy data from Sheet1 to Sheet2 displaying only those rows with the highest values from Sheet1.
Have a look at the following screenshot of "Sheet2":
In the above sheet I have the following formula in Cell A1:
=query(Sheet1!A:C;"select A,B,max(C) group by A,B order by max(C) desc label max(C) 'Value 2'";1)