New answers tagged

0

So, I was pointed in the right direction by marikamitsos, thank you! However, I found a slightly different solution. =QUERY($C$3:$D$53,"select D where C='TER 2'") This article helped a lot > Google Sheets Query


0

Try a query instead. In cell F4 try the following formula: =IFERROR(QUERY($C$3:$D$52,"select D where C='"&G$3&"'"),"") You can even drag the formula from F3 to the right and all of the rest will auto-fill. Functions used: QUERY


0

Instead of 249 static formulas you can use just 3 dynamic ones. For your 1st set use the following on cell A3 =QUERY(ArrayFormula(((IFERROR( VLOOKUP(SORT('solution Stats Gathering'!K3:K,1,0), ({'solution Stats Gathering'!K3:K,'solution Stats Gathering'!A3:L}),{2,3,12},0) )))),"select * where Col1 is not null") For the ...


0

=SORT(A2:A,ARRAYFORMULA(MATCH(A2:A,C2:C,0)),1)


Top 50 recent answers are included