Thread: Top 10 Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] easwara@gmail.com is offline
external usenet poster
 
Posts: 3
Default Top 10 Values

Hi All,

Assume I have two excel files. I'm having a file with the following
values in a workbook called First.xls under worksheet called 'data'. I
need to find the top 5 values and populate these values in a another
workbook(second.xls) in a worksheet called 'top 5 values'. How it can
be done? is it thru VBA or just thru functions like LARGE? Please help
me, as I'm not an expert in Excel.

Thanks
Easwara.

Data:

A1:A10
28
0
8
1
27
23
8
211
43
33