- Column T contains same week several times. Can it be just once like for January Week 1, Week 2 .... Week 6.
- The formulae in J52 and K52 are to be applied for columns U and V using same conditions but as per Weeks under column T.
- Also, column R is just for reference. Can column S and T be populated without the need of column R so that it can be removed?
Please see the attached.
RE: Question 1 --- I was unable to use Table syntax for this thread. Table syntax for formulas like these get awkward in the extreme. See this formula in T52
Question 2 --- These two formulas in J52 and K52 respectively
Question 3 --- My first thought is "Yes, probably." My next thought is "I wouldn't advise it. Table syntax renders required formula workarounds extremely awkward."
Bookmarks