Excel 2007 : multiple y values for same x values , want the bigger y

[gorge4355]

A B
00:10:40 16.07
00:10:40 10.6
00:10:41 15.9
00:10:41 10.6
00:10:42 15.9
00:10:42 10.6
00:10:43 15.9
00:10:43 10.6


Hi I am new to excel. Column A is the x values and Column B is the y values. What I need is only one x value and corresponding larger y value ( no duplicates ). Something like

A B
00:10:40 16.07
00:10:41 15.9
00:10:42 15.9
00:10:43 15.9

Any formula to do that . thnx

[shg]

Assuming the x values really are duplicates, sort by x ascending and y descending, then select col A and do Data > Remove Duplicates

[gorge4355]

it doesnt work . I want to explain more on this thing.
I have two columns A and B . On column A I have some time values and on B some measured distance values. As mentioned in my first post in this thread , on some particular seconds I get multiple distance values ( column B ). But I need to have only the greater distance value in that second.

I have a huge database and manually selecting the highest value associated with a particular time value is a time consuming and inefficient way .

The excel file that i am currently working on is attached here.

thanks in advance. really need some help.

[Marcol]

Try this
Create two non-volatile dynamic named ranges
1/. Name:= "Times"
Refers to:=

=Sheet1!$A$2:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A),1)

1/. Name:= "Distances"
Refers to:=

=Sheet1!$B$2:INDEX(Sheet1!$B:$B,COUNTA(Sheet1!$A:$A),1)

Then in C2 this array formula

=IF(B2<>MAX((Times=A2)*(Distances)),"Delete","")

Confirm with Ctrl+Shift+Enter not just enter.
Drag/Fill Down.

Filter Column C for "Delete" select the resulting rows and do just that.

Is that what you need?

[gorge4355]

@Marcol

Brilliant , thanks a lot
really appreciate your help .