Forum Discussion
Solved
Nesting SortBy and Filter functions
Can someone suggest where I've gone wrong with this syntax please: =SORTBY(FILTER(Worklist,List!I2:I500=0),List!A2:A500,1,List!G2:G500,1,List!E2:E500,1) Currently returning the #VALUE! error....
=FILTER(SORTBY(Worklist,List!A2:A500,1,List!G2:G500,1,List!E2:E500,1),List!I2:I500=0)Does this return the intended result in your sheet as well?
Currently i can't attach a sample file that's why i've added a screenshot that shows the output if the data is in the same sheet. The shared formula works across sheets in my sample file.
Thanks both Oliver and m_tarler - much appreciated.
Oliver, not sure I follow your syntax directly after SORT (what are the other letters?) but the screenshot isn't too clear.
MT, some of those functions are not familiar to me so I'll need to study them!