OK, I have attached ex 4.
1. If I delete colm Z and AA then colm AE and AF get #REF! in the cells.
2. I do not need colmn Z and AA, which can be deleted.


3. In colmn AE I have 2 Logan Wakefield (greyed out) which I do not understand how or why
4. If I add a name (person joining) what must I do? 2nd grey cell

I know this is taking your time and I am thankful. I can hide colmn if necessary.

Attached Files

EXample_4.xlsx (16.2 KB, 9 views)

At present the formulas span the rows 5:26. If you extend that range in your table you must adjust the formulas accordingly.

Please note that the formulas in column AF are array formulas. They are special in that they must be entered a certain way. Where you normally just press Enter when finishing a formula, an array formula must be entered by holding down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. Don't try to enter these braces manually. This will just lead Excel to think it is a text string and not a formula. When you have entered one array formula correctly you can copy to other cells as you normally do.

You can hide column AB:AC if you want or you can move the formulas in those columns to another place.

Attached Files

EXample_5.xlsx (15.0 KB, 9 views)