View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] staeri@gmail.com is offline
external usenet poster
 
Posts: 35
Default Find first row with given value

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