LinkBack URL
About LinkBacks
Hi everyone,
I basically need to use "large" formula with multiple arrays. How can I do this ?
Hi everyone,
I basically need to use "large" formula with multiple arrays. How can I do this ?
Last edited by metal.stuff; 07-04-2016 at 07:11 AM.
Double post sorry
Last edited by metal.stuff; 07-04-2016 at 07:11 AM.
Maybe something like this...
Data Range
=LARGE((A1:A5,C1:C5,E1:E5),2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you!
Now my second part of the question, I need to link the result with another value in the same column...
I tried like this:
=INDEX(AR5:BI5;MATCH((LARGE((AS6:AV6;AY6:BC6;BE6:BH6);1));(AS6:AV6;AY6:BC6;BE6:BH6)))
But it gives me n/a...any idea ?
Can you post a sample file and tell us what result you expect?
Im sorry, but its work related and ths classified...I can make a proxy but it will take a while, its quite difficult to explain...Originally Posted by Tony Valko
It doesn't need to be a gigantic file. It's only a SAMPLE file!
This will give you the cell reference to the value obtained by Tony Valko's formula using his example range of values.
Enter with Ctrl + Shift + Enter where you want the result. This is an array formula.
Formula:
Please Login or Register to view this content.
You should be able to use the value returned to link with the other value in the column that you are interested in.
Last edited by newdoverman; 07-04-2016 at 09:59 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Ok I made a little example to show you what i need.
Basically, I want the tier marked in the orange to index match the tier of the weapon in the first table.
This is a very simplified version of what i need, but u can see the n/a in there....
I downloaded your file but I can't figure out what you're wanting to do.
Basically I wanted to index match the largest number 1 and largest number 2 with the indexed cellsI downloaded your file but I can't figure out what you're wanting to do.
How about filling out your form so that it is more easily determined what you are trying to do.
Are there really that many duplicated values in your real data as you show in the data?
Yes, the original excel is like 10x larger.
BTW which post r u talking about ?
This is just a guess from the patterns I see in the formulas and following through with those. In L7 and filled down.In N7 and filled down.Formula:Please Login or Register to view this content.Are the results what you are expecting?Formula:Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks