I have 4 coloums D,E,F,G and I want to find the MAX and MIN of D4:D5203, E4:E5203, F4:F5203, G4:G5203. Then find the cell where the max and min occors and copy the entire row at the bottom of the sheet (or in e new sheet if it is easier). In other words I have max of the column D, then I want copy the row where it occours with the corresponding values, max column E and copy the row and so on. The same for the minimum, in total I shoud have 4 rows for the max and 4 for the min, hope someone can help. Many thanks!
Tom
Tom