Forum Discussion
anshul1983
Aug 06, 2024Copper Contributor
Formula to view only certain rows that fulfills few conditions
Just want some help on this table as one can see the data in these table. I just want to view only few rows which fulfill few of the conditions. 1) Volume is greater than 5000. 2) Values in row of ...
Rodrigo_
Aug 07, 2024Iron Contributor
Use filter function
=FILTER(Sheet1!A2:H35;
(Sheet1!B2:B35="PE") *
(Sheet1!D2:D35 + Sheet1!E2:E35 + Sheet1!F2:F35) >10%; "")
sample file > anshul1983.xlsx - Microsoft Excel Online (live.com)