Save the row/record for the highest producing member for each team

[Pumpk1n]

In Access,I can sort by region by highest producer and save that record for further processing. I have to convert the Access DB functionality to excel. I know I can sort in excel, but how do I save/copy just those highest producers in a separate tab. Does excel or sql have a “first” function that I can use?

 

[Coding4Fun]

I might be off on your request but if I understand correctly, lets say your data is on Sheet1 and you want to copy the first 10? 20? 30? rows to Sheet2, correct?

If you always want to bring over the same number say the top 10 or top 20 then you could do so by first sorting Sheet1 so that the top 10 rows (11 with a header) are the results you want to copy.

Then in Sheet2 in cell A1 put in

=Sheet1!A1

Then copy it down A1 to A11 (A2 to A11 if not copying the header)
Then copy if over across your columns as needed.

=Sheet1!B1
=Sheet1!C1
=Sheet1!D1

etc.