New answers tagged

0

You are missing that formulas are recalculated automatically. Formulas that use built-in functions are recalculated when the spreadsheet is opened and every time that a change is made. Instead of using the sort functions of the UI, you could include in your formula SORT (the built-in function), rebuild your formula and use QUERY (another built-in function) ...


0

One cell solution: Combining the FILTER Function with the COUNTIF function provides you with the list you want: =FILTER(A:C,COUNTIF(D:D,A:A)=0)) In this example I used the Key as the matching field comparing column A with matches in D but it works with the other columns as well.


0

=IFERROR(PRODUCT(IFS(H2="x",VLOOKUP(D2,Products!$B$2:$I$100,3,0),I2="x",VLOOKUP(D2,Products!$B$2:$I$100,4,0),J2="x",VLOOKUP(D2,Products!$B$2:$I$100,5,0)),E2),"") was able to achieve this with a little assistance from a friend


Top 50 recent answers are included