| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
| Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming | |||
Threaded Mode
