Referencing all cell of merged cell as individual
I am facing problem while referencing all cell of merged cell as a individual cell, because its take first col first row of merged cell as reference cell in any formula.
Ex. in Attachment example case i have some data in column A, I have formula in Column B as RC[-1], and result showing as column B, but i want output as column C.
Here's the best advice anyone can give: do NOT used merged cells. Get rid of them.
In B2 copied down:
=IF(A2="",B1,A2)
Last edited by AliGW; 09-23-2021 at 10:01 AM.
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.
Thank You madam!!, but in detail sheet I have blank cell also in Column D as per attested excel TEST CASE 2. i am getting output as per Column E and I want Output as per column F.
Well, that’s a completely new sample sheet - I could not have known that you also have completely blank cells from your original sample. Did you expect me to guess this?
My original advice remains the same: ditch the merged cells.
Mam, You are absolutely Right, that in my previous example i did not mentioned that i have also some blank cells in list, and You obviously not guess that...
and mam, the requirement of merged cell is there because there is a box of some items, so we can not remove it...
please guide for any better solutions, which consider blank cell also and i can get output as per column F, it will becomes a great help to me...
Thanks In Advance
Paras
Sorry - I made the decision some time ago not to help where merged cells were non-negotiable. There is NEVER a good or legitimate reason for using them.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks