LinkBack URL
About LinkBacks
Welcome to the forum.
Why are you looking at entire ranges in these formulae? If L6:L11 are merged, you only need to reference L6.
Welcome to the forum.
Why are you looking at entire ranges in these formulae? If L6:L11 are merged, you only need to reference L6.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi AliGW. Thank you so much for your reply. I've switch to referencing a single cell (i.e. L6) and the formula now works so that has solved my problem very quickly. Many thanks.
The reason I initially had the range was that when I clicked in the cell to add the cell reference to the formula the full reference was added (i.e. 'Operating Model Assessment 1'!$L$6:$L$11). Nevermind though as I will remember your advice for future and ensure to change this to the single merged cell reference.
Thank you and best wishes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks