# Single Max value in group

#### Waqas ali

##### Board Regular
I have a query which gets max value in group by clause but want to show only one max value of same group with all records of same group.
Ali 5
Ali 4
Ali 3
I want to see only.
Ali 5
Ali
Ali
How?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
It's not clear how the output must be created.

Is this what you want?

 Row\Col A​ B​ C​ 1​ Name Value Max 2​ Ali 5​ 5​ 3​ Ali 4​ 4​ Ali 3​ 5​ Veli 1​ 7​ 6​ Veli 7​

Yes thanks

Yes thanks

C2, control+shift+enter, not just enter, and copy down:

=IF(ISNA(MATCH(A2,\$A\$1:A1,0)),MAX(IF(\$A\$2:\$A\$6=A2,\$B\$2:\$B\$6)),"")

My friend not in excel.
I need in access query.

Can any one do this

Dear all i need this result via query in access can any one help

Dear all i need this result via query in access can any one help

This should be in Access forum. If it was, I would definitely not have provided a spreadsheet solution. That said: you can better specify the table(s) you have in the following format:

Example...

Try:

Code:
``````SELECT X.Name, X.Value, IIf([Value]=(select first(Value) from DataTable where Name = x.Name),(select max(Value) from DataTable where Name = x.Name),"") AS Expr1
FROM DataTable AS X;``````

Replies
5
Views
175
Replies
1
Views
270
Replies
2
Views
158
Replies
1
Views
235
Replies
6
Views
308

1,203,140
Messages
6,053,727
Members
444,681
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back