Forum Discussion
Solved
Conditional formula
Hi Everyone, I'd be really grateful if anyone can help me with following issue. I have two sheets where i need to copy data from Sheet1 to Sheet 2 when condition is met. In Sheet1 i have multip...
You can use:
=FILTER(Sheet1!A2:B5,(Sheet1!A2:A5="LTI")+(Sheet1!A2:A5="MTI"))
Change ranges accordingly if this is data that can be enlarged with time. Also, remember to format cells from "Date" column from Sheet2 as dates.
You can use:
=FILTER(Sheet1!A2:B5,(Sheet1!A2:A5="LTI")+(Sheet1!A2:A5="MTI"))
Change ranges accordingly if this is data that can be enlarged with time. Also, remember to format cells from "Date" column from Sheet2 as dates.