• 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.

Bank Ledger Customization

Shabbo

Member
Dear Sir,

I wanted your help to I have bank ledger and cheque numbers are coming in narration only which I wanted to put cheque number column in front of debit amount.

Please advise.
 

Attachments

  • Bank Ledger Customization.xlsx
    26.8 KB · Views: 12
Shabbo
Why Your sample has marked with red some RefNo's instead of Your needed cheque number?
For cell D5 =iferror(MID(C5,FIND("ChqNo:",C5,1)+6,FIND("ChqDate:",C5,1)-FIND("ChqNo:",C5,1)-7),"-")
and copy as needed.
PS. Have You read Your: https://chandoo.org/forum/threads/data-summary-using-excel-formula.41874/
Dear Sir,
This formula works but my question went wrong actually the reference number and cheque number should be in Column D4 and not D5.
In short it should be in front of Receipt and but its coming in front of blank column.
please advise.
 
Shabbo
If You ask this ... and mean that ... You'll get this ... not that.
Test to copy that formula to ... cell D4 ... then You'll get this to cell D4.
If You still would like to have something else then sit down and think ... what would You really like to have?
You have had same kind of 'Bank Ledger Customization'-thread many times.
... have You noticed?

... and answer question: Have You read Your...
 
Back
Top