Forum Discussion
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 multiple Event types that are used but i only need the data when there is LTI or MTI together with the date to be copied in sheet2.
I have uploaded a file with the details of what i mean.
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.
1 Reply
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.