Write excel formula …in columnd D and E with if condition to check for success in C …then add fata from A and B else leave them blank
"=IF(C2=""SUCCESS"",A2,"""")"
Then use auto fill ramge to fill till bottom…similarly for B and E columns
Cheers
Write excel formula …in columnd D and E with if condition to check for success in C …then add fata from A and B else leave them blank
"=IF(C2=""SUCCESS"",A2,"""")"
Then use auto fill ramge to fill till bottom…similarly for B and E columns
Cheers