Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I also want to thank Bob. This is something I've been scratching my head over for a week or so. Finally resorted to searching on the Internet rather than the masochistic pleasure of trying to work it out for my self. So far I've only tried Bob's original suggestion (LARGE / INDEX) and it's great. It is true that if you have two results exactly the same then there is a problem. With my needs I am happy to add a very small, unique (0.000x) number to the original. Therefore every number will always be slightly different, then I can just show the final number to only 2 decimal places. Regards William *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Sorting? | Excel Worksheet Functions | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
automatic sorting | Excel Discussion (Misc queries) | |||
Automatic sorting | Excel Worksheet Functions | |||
automatic sorting | Excel Worksheet Functions |