I need to capture week over week performance and spreadsheet has both week one and 2 combined.
Need to subtract week 1 from 2.
Column C — identifying number for each name
Column A identifies week 1 or week 2
Column K has the value for specific week
So, if column c has matching number in Column C, Subtract K for week 1 from K for week 2
I have tried using an iferror formula but get errors and am not sure where to start
New contributor
Joe is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.