[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Large function in excel on ARRAY

I want to grab the 3rd largest value from a set of cells however the large function is not working.

here is the formula that is not working:

=large({F10,F20,F30,F40,N40,N30,N20,N10,U10,U20,U30,U40,AC40,AC30,AC20,AC10},3)
0
ClaudeWalker
Asked:
ClaudeWalker
1 Solution
 
jppintoCommented:
Change your {} for (), like this:

=LARGE((F10,F20,F30,F40,N40,N30,N20,N10,U10,U20,U30,U40,AC40,AC30,AC20,AC10),3)

jppinto
0
 
ClaudeWalkerAuthor Commented:
PERFECT!

Thanks,
JOe K.
0

Featured Post

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.

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