Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with accounts which have stocks going from the
biggest negative change in value to the biggest postive change in value. I need to get the top 5 of each (positive and negative) but one account could only have 3 top and 2 bottom for example. Sample: Account Curr Stock diff .. .. .. 11200 JPY a 50 11200 JPY b 2000 11200 JPY c 3000 13400 GBP d -9003 13400 GBP e -653 13400 GBP f -23 13400 GBP g -2 .. .. .. In this example, account 11200 only has 3 top positive but 13400 has 4 top negative. I need to go down the list and get the info for all accounts to a max of 5 top pos. and 5 top neg per account. I would appreciate any help I could get on this issue. Thx Mat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
Need step by step for entering data into combobox | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |