May 03 2019 11:57 AM
I am trying to create a formula that will copy a row if a specified field contains a specified value. For example, in the below sheet, I would like to copy the 1st row to the Complete tab, 2nd row to Fail tab and 3rd to Pass tab. Is this possible, if so what would the formula be?
3/25/2019 | 7:15 AM | 1 | Notification to Testers | Send notification to testers of scheduled tests for the day | John | Complete |
3/25/2019 | 7:30 AM | 2 | Update Params | Update params | Josie | Fail |
3/25/2019 | 7:30 AM | 3 | Projected Pmt Int | Validate DTCC's Projected Payments | Emma | Pass |
May 03 2019 12:46 PM
@dtripp_1961 , if you want to copy, not to move, you may use Power Query quering first sheet and land filtered results into other sheets.