I attach a new file where I have made helper cells in N2:N15. You can hide this column if you want or move it (not copy) to another place out of sight.
Are you aware that array formulas like thos in G3:K4 must be entered in a special way. Normally you just press Enter to complete a formula. Array formulas 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. When you have entered one array formula correctly you can copy it to other cells in the normal way. Don't try to enter the {} manually. If you edit an array formula you must again hold down Ctrl and Shift before pressing Enter.
|