On Sheet2 I've add a formula.
You need to extend it to right and down as much as you have your data (or more).
Then you can use formula in Sheet1.
(Hint: You can hide Sheet2 if you like)
On Sheet2 I've add a formula.
You need to extend it to right and down as much as you have your data (or more).
Then you can use formula in Sheet1.
(Hint: You can hide Sheet2 if you like)
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks