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], "")
OliverScheurich
Sep 05, 2025Gold Contributor
In the attached file is a possible solution with a formula and with Power Query.