Dear Experts
I am trying to get the value from CW column to CA column (It is a printable table structure starting from CA4 to CA30)
CA4= IF(BW="","",BW4) dragable till CA39
I am trying, but could not attain that I need "End of List" at the very first blank cell.
I tried this formula but error: cirucular reference
=IF(CA4<>"", CA4, IF(COUNTBLANK($CA$4:CA4) = 1, "End of List", ""))
Please help. Attached Image for your kind reference
Screenshot 2023-09-28 174134.png
Thank you!
You have posted in the VBA section, but seem to want a formula ... ???
Which version of Excel are you using?
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thank you for response
I am using Office Standard 2021 version
I have attached the sample workbook for reference.
thank you for pointing out.
Please update your forum profile.
Do you want a formula or VBA?
If I get help from Formula will much easier.
If not It will be helful even it VBA also
On Guess.
In CA4 ARRAY formula. Copy down.
Formula:
Please Login or Register to view this content.
To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hello Sir
Thank you so much. Your file works with your formula
Unfortunetly it is not working with my merged cell file. yes, its my mistake i should have posted including merged cell. I thought it will be easy to explain, but when I tried to implement your array formula it gives me jumping result. sorry this time i have attached with extact merged cell.
Kindly Please help with file. thanks a lot
Try this macro.
Suggestion:
Please Login or Register to view this content.
It is not advisable to use merged cells. It is very difficult to Apply formulas and macros. Only in inevitable situations merged cells should be used.
If possible remove merged cells and use formula. If not Macro can be used.
Last edited by kvsrinivasamurthy; 09-28-2023 at 05:57 PM.
Thank you so much for your VBA coding, It helped
I am requesting you one more help in same scenario
But this time my data starts with INPUT!G19 toG45 (source data
Destination cells J1604, J1605... (this is not MERGED cells,
I tried your formula which your formula - you have provided earlier post.
It gives "End of List" at the top row itself
Your help to Solve this final task, will be much usefulAttachment 844257
Attachment not opening. Pl upload file like Post $3.
skhari,
Do yourself a favor and avoid using merged cells. They can create all kinds of problems. Avoid their use at all costs.
"Oh Well..Whatever..Nevermind" - Kurdt Cobain
Doesn't matter merged or unmerged.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks