Find first row with given value

S

staeri

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
 
B

Bernard Liengme

Assuming the 'objects' are in A1:A6 and the 'sort order' in B1:B6, then
=MIN(IF($A$1:$A$6=A1,$B$1:$B$6,""))
works for me when entered in to C1 as a array formula (ie using
CTRL+SHIFT+ENTER) and then copied down the column
best wishes
 
M

Marcelo

Hi,

=vlookup(a2,$a$2:$b$7,2,0)

copy it down

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"(e-mail address removed)" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple table lookup 13
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
How do I DMAX only part of a column? 2
Problem with query 0
Help with this query, please? 1
Adding sequence numbers to paragraphs 0
Loop 1
List all tables, including document structure 0

Top