Forum Discussion
Solved
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti =...
Slightly shorter in E2:
=IF(Table3[rnti1]=E1:G1, Table3[corr0], "")
To play with formulae it could be
=DROP( PIVOTBY( SEQUENCE( ROWS(Table3) ), Table3[rnti1], Table3[corr0], MIN, ,0,, 0),, 1)but performance is disappointing, it takes years to calculate