Hi guys,
I'm trying to create a tallysheet to help me map out the subjects hits per scenario.
What I'm trying to achieve is to list down the subjects based on which path was taken first (rank 1 to 10 etc) per scenario.
#=IFERROR(INDEX(Tally!$A$2:$A$77,MATCH(LARGE(Tally!$C$2:$C$77,ROWS(Tally!$C$2:C2)),C2:C77)),"")
The above formula doesn't seem to work??? Any help you can provide will be much appreciatedTally Sheet.xlsx
Try array-entering this formula in B1 and fill down.If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
Please Login or Register to view this content.
Does this get things started in the right direction?
Edit The sheet name was missing in the 2nd argument of MATCH. I also set the 3rd argument to 0.
Last edited by FlameRetired; 12-02-2015 at 11:52 PM.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks