Looking for formula to extract values from H3:T19 into J23:T26 if conditions i21 (Apple) and I23:26 are met. Sample file attached.
Thanks.
Looking for formula to extract values from H3:T19 into J23:T26 if conditions i21 (Apple) and I23:26 are met. Sample file attached.
Thanks.
Last edited by bjnockle; 08-05-2017 at 10:20 AM.
j23=LOOKUP(2,1/(($I$4:$I$19=$I$21)*($H$4:$H$19=$I23)),J$4:J$19)
Try this and copy acrossPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
In J23
=INDEX($J$4:$T$19,MATCH($I23&$I$21,$H$4:$H$19&$I$4:$I$19,0),MATCH(J$22,$J$3:$T$3,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Copy across and down
your manualy result don't match Always the criteria apple east is 53%.
With power query to rearange the data.
After that a pivot table.
See the attached file (in sheet Oeldere).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
nflsales: works like a charm. Thanks nflsales.
JohnTopley: your approach works great, JohnTopley. Thanks friend.
oeldere: love the Pivot table approach. Thanks alot friend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks