Link to home
Create AccountLog in
Avatar of Member_2_5230414
Member_2_5230414

asked on

Get largest number in a Coumn where cell =?

Hello,

I would like to get the Largest value from column O where the cell = 1.

I have tried =LARGE(Result!'O:O = 1', 1) but it does not work??

Any help would it be great!
Avatar of Angelp1ay
Angelp1ay
Flag of United Kingdom of Great Britain and Northern Ireland image

Surely the largest value is 1?

Could you perhaps post the Excel so I understand better?
Avatar of Rob Henson
It looks like you might need the DMAX function.

=DMAX(Data,Header,Criteria)

Data - Data range to be assessed
Header - Header of column from which you want the result
Criteria - Header and criteria required

Criteria will be in a small range (at least 1 column and 2 rows) of its own with the same header in your case as the column from which you are checking for the number 1 and the value 1 in the cell below it.

Thanks
Rob H
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Member_2_5230414
Member_2_5230414

ASKER

I have tried the above and I still get the #Value! error.... I repeated it a few time so i attached the sheet on here to check i did it right
J.P.B.S.xlsx
NO POINTS FOR THIS.

Follow byundt's instructions. In my words

Select the cell
Press F2
Press Shift-Ctrl-Enter
It worked thank!!!
Another excellent learning thread! Also thanks, never knew about array formulas before this :)