Forum Discussion
anupambit1797
Sep 05, 2025Iron Contributor
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 =...
- Sep 05, 2025
Slightly shorter in E2:
=IF(Table3[rnti1]=E1:G1, Table3[corr0], "")
HansVogelaar
Sep 05, 2025MVP
In E2:
=IF(Table3[[rnti1]:[rnti1]]=E$1, Table3[[corr0]:[corr0]], "")
Fill to the right to F2 and G2.