| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
please help me program excel to scan for top 10 highest values
Many thanks Tom I will try this asap
"Tom Ogilvy" wrote: The results will be repeatable, but may be repeatably incorrect if any of the companies in the top 10 share the same risk rating. -- Regards, Tom Ogilvy "Mike H" wrote: Nick, You can have a macro if you want one but this is less work and guaranteed to give repeatable results. Risk rating in column C Company name in column D This in E1 =VLOOKUP(LARGE(C$1:C$1000,ROW()),C$1:D$1000,2,FALS E) Drag down to E10 for top ten risks. Mike "Nick" wrote: Hello Please help. I'm trying to program Excel to run down a column of values, taking the top 10 highest values and populating another worksheet with the adjacent reference for these values. For example If I have company registration numbers in one column and their corresponding credit risk ratings in another column, I want excel to populate another worksheet with the registration numbers of the top 10 most risky companies . I can do this manually, but I want add a button so that my colleagues can perform the same action with exactly the same result. Any hints would be much appreciated and I would be willing to make a donation Many thanks in advance, Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 3 highest values | Excel Discussion (Misc queries) | |||
| How do I scan a large table/worksheet for values? | Excel Programming | |||
| 3 highest values | New Users to Excel | |||
| how do i disable "running virus scan" in excel program when opened | New Users to Excel | |||
| scan for repeating values and then delete | Excel Programming | |||
Threaded Mode
