Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Win XP Pro
MS-Office XP In a workbook I have a sheet that results in a column of random scores via "large" formula: {=large$AZ$4:$AZ$53,ROW(1:1)))}..... From this "large" formula the results are shown in another sheet from highest score to lowest scores (eg. 434), including competitors name. Now I have 2 players with a score of 434 in above mentioned column, using "index/match functions, but it repeats the fisrt name with 434 instead of 2 different names. It works OK if scores are all different. I wonder if I may incorperate "round" function in the "large" formula ?? From a non IT senior citizen... Regards Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column of negative numbers into positive numbers | Excel Worksheet Functions | |||
Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
Match Column B numbers to Column A numbers | Excel Worksheet Functions | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions |