Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following values in column A (object name) and B (sort
order): O1 | 1 O2 | 2 O2 | 3 O2 | 4 O3 | 5 O3 | 6 In column C I want to return the lowest B value for each object name in column A. That means I would like to get the following result: O1 | 1 | 1 O2 | 2 | 2 O2 | 3 | 2 O2 | 4 | 2 O3 | 5 | 5 O3 | 6 | 5 If someone please can help me immediately with a function I'm forever grateful since I have a deadline to catch now... Regards, S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |