Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi , i need help to write a user defined functions to find positive
maximum and positive minimum and also negative maximum and negative minimum from a range consists of both positive and negative numbers. ex: 15,18,12,7,3,-9,-13,-23 In my requirement the result should come as Positive Max: 18 Positive Minimum :3 Negative Maximum: -9 Negative minimum : -23 Thanks in advance for your response. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a maximum/minimum date in 2006 | Excel Discussion (Misc queries) | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
Finding negative and positive diffrence | Excel Worksheet Functions | |||
Automatic formatting of minimum/maximum value in a range. | Excel Discussion (Misc queries) |