| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
I did
"Anthony Slater" wrote: The formula is fine. As its an array, you have to enter the formular ctrl=shift-enter "AZExcelNewbie" wrote: I have a vertical array which worked fine in another worksheet but does not work now. It looks at a set of cells and sorts them from high to low, currently it will find the highest number, but when you auto fill the cells below it, it shows duplicate entries all the way down. Please let me know what I'm doing wrong with the following formula: =INDEX(A$2:A$76,MATCH(LARGE($B$2:$B$76-ROW($B$2:$B$76)/75^75,ROWS($A$2:A2)),$B$2:$B$76-ROW($B$2:$B$76)/75^75,0)) column 'a' contains names, column 'b' contains the number. There are 75 entries. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| How can I use a cell reference in Sumproduct array formula? | Excel Discussion (Misc queries) | |||
| Array Formula | Excel Worksheet Functions | |||
| IF(ISNA formula problem | Excel Worksheet Functions | |||
| Help with array formula | Excel Worksheet Functions | |||
Threaded Mode
