• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Get largest number in a Coumn where cell =?


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!
1 Solution
Surely the largest value is 1?

Could you perhaps post the Excel so I understand better?
Rob HensonFinance AnalystCommented:
It looks like you might need the DMAX function.


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.

Rob H
I'm guessing that what you want to do is search say column B for cells containing 1. On those rows, look for the largest value in column O. If so, consider an array formula like:

To array-enter the formula:
1.  Click in the formula bar
2.  Hold the Control and Shift keys down
3.  Hit the Enter key, then release all three keys
Excel should respond by putting curly braces { } surrounding the formula. If not (or if you see #VALUE! error value), then repeat steps 1-3.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

runnerjp2005Author Commented:
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
Saqib Husain, SyedEngineerCommented:

Follow byundt's instructions. In my words

Select the cell
Press F2
Press Shift-Ctrl-Enter
runnerjp2005Author Commented:
It worked thank!!!
Another excellent learning thread! Also thanks, never knew about array formulas before this :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now