• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Concatenate / Textjoin based on certain criteria

Status
Not open for further replies.
CA Rohit

CA Rohit

New Member
Hi All,

I have recently converted a pdf bank statement into an excel. However, few of the description has been split into two cells, resulting in extra line. I need a formula to combine the split cells into one cell based on date column. Attaching an excel sheet for reference.

I am thinking of using concatenate and offset, but struggling with the same.

TIA
 

Attachments

  • Sample.xlsx
    10 KB · Views: 6
Juniad said:
See the result in attached file with helper column. Hit Like if you find it useful.:)
Click to expand...
Dear Sir, I tried to use your clever formula in your sample (1) workbook I found if the date in Row 19 marked in yellow is duplicate the formula in cell F19 is not correct it's pulling the data from the above Cell F16 may I kindly request you to review the formula to accept duplicate dates your assistant is highly appreciated
 

Attachments

  • Screenshot (2101).png
    Screenshot (2101).png
    61.9 KB · Views: 3
Last edited:
geo Jul said:
Dear Sir, I tried to use your clever formula in your sample (1) workbook I found if the date in Row 19 marked in yellow is duplicate the formula in cell F19 is not correct it's pulling the data from the above Cell F16 may I kindly request you to review the formula to accept duplicate dates your assistant is highly appreciated
Click to expand...
You'll have better luck getting an answer starting your own thread vs replying to others/old threads
 
Status
Not open for further replies.
Back
Top