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 = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty
Attached is the worksheet,
Br,
Anupam
Slightly shorter in E2:
=IF(Table3[rnti1]=E1:G1, Table3[corr0], "")
4 Replies
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
Slightly shorter in E2:
=IF(Table3[rnti1]=E1:G1, Table3[corr0], "")
In the attached file is a possible solution with a formula and with Power Query.
In E2:
=IF(Table3[[rnti1]:[rnti1]]=E$1, Table3[[corr0]:[corr0]], "")
Fill to the right to F2 and G2.
