Yep, that's always a challenge. And I am regularly on the novice as well as the expert side of that communication breakdown.

That's why attached sample files go so much further than descriptions only or even screen captures. I thought I could get away without, but if you (who apparently has a breadth of Excel knowledge) don't understand me, what hope is there that the OP does?

Anyhoo...here are a few screen captures of the Name Box that I was talking about. In this case, I selected the A1 address in the Name Box and typed RFA in it to quickly name the cell.

Attached is a sample file of the table automation and the resulting formulas. See in Column C how the formulas are descriptive rather than merely referring to addresses.

I'm not sure if this makes my original post any clearer.

Attached Files

RFA+RRA.xlsx (8.9 KB, 10 views)