IF Function help!

Copper Contributor

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/20197:15 AM1Notification to TestersSend notification to testers of scheduled tests for the day

John

Complete
3/25/20197:30 AM2Update Params Update params JosieFail
3/25/20197:30 AM3Projected Pmt IntValidate DTCC's Projected Payments EmmaPass 
1 Reply

@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.