Most Excel users would copy paste a formula even _within_ the same table, and don't know that Excel's built-in 'Tables' allow you to automatically keep a formula consistent between rows.
I'm not sure whether there's a good answer to your question
If there is, I'm sure that most 'Excel pros' don't know it.
I'm not sure whether there's a good answer to your question If there is, I'm sure that most 'Excel pros' don't know it.