CODEWITHSUNDEEP
arraysexcelexcel-formula
Telenoobies
Telenoobies

Reputation: 936

Array formula, return only 1 specific value

I have a question for Excel's Array formula.

I have an array formula that returns 10 different values. If I only want to the 5th value, how do I do this? I believe there is a formula, but i'm not sure what it is.

Thanks in advance.

Upvotes: 0

Views: 5102

Answers (2)

nullrevolution
nullrevolution

Reputation: 4117

a very similar question: Excel. Access single value from array function

short answer: the =index() function is what you're looking for.

Upvotes: 0

Charles Williams
Charles Williams

Reputation: 23505

You can use the INDEX function: {=INDEX(arrayformula,5,1)} or {=INDEX(arrayformula,1,5)} depending whether your array formula returns rows or columns

Upvotes: 3

Related Questions