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!
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!
Microsoft ExcelVisual Basic ClassicVB Script
Last Comment
Angelp1ay
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
=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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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
Follow byundt's instructions. In my words
Select the cell
Press F2
Press Shift-Ctrl-Enter
ASKER
It worked thank!!!
Another excellent learning thread! Also thanks, never knew about array formulas before this :)
Could you perhaps post the Excel so I understand better?