Thread: Selecting rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Withnails Withnails is offline
external usenet poster
 
Posts: 16
Default Selecting rows

Hi
I am looking to view the data in column k2 to the end of the available data,
and copy the rows that column that house the 3 largest values and 3 smallest
values, before copying the six selected rows into the next worksheet
(worksheet 3).
Any idea of how this can be done?