[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • 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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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