Hi
Task tracker.xlsx
A group of operatives have weekly tasks. They submit the results to me which I enter into a spreadsheet like the above simplified version.
Some tasks need to be assigned a code (the variants are shown in rows 1 to 3). If a task code is entered in any of the columns from C onwards I want the same code and conditional formatting to show directly after their name in column B, as per the example for Joe.
Joe had L1 for task 2 but as L3 is higher level, task 3 code overrides L2 in column B. Same with E codes. Joe hasn't had any P codes yet so it remains unchanged in column B.
I hope my explanation is clear but please ask if not.
What I need is a formula in column B to change the content according to the task codes. I've spent a lot of time trying to work out how to use the IF function but it's taxing my brain power too much, hence my visit here to see if anyone can assist!
Bookmarks