How to Sort Debit and Credit Amount Using Formula In Excel

15 Просмотры

Спасибо! Поделитесь с друзьями!

Вам не понравилось видео. Спасибо за то что поделились своим мнением!

Издатель Mar 22, 2026

*How to Sort Debit and Credit Amount Using Formula In Excel*

In this short excel tutorial I'll show you how you can sort debit and credit amount in excel using formula. In the given scenario the formula to sort debit is: =IF(B2="Dr",C2,"") and the formula to sort credit is as follows: =IF(B2="Cr",C2,""). Once you place the formula to your debit and credit cell it will extract only debit amount to debit cell and credit amount to credit cell based on dr and cr initials on column B.

#excelformula #learnExcel #accounting
Thanks for watching.
----------------------------------------------------------------------------------------
*Become a member and enjoy exclusive perks while supporting the channel you love!:*
https://www.youtube.com/@Excel10tutorial/join
*Support the channel on Patreon*
https://www.patreon.com/join/excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe for more excel tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

*Playlists:*

Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Data Validation: Allow Specific Entries, Dates, Dropdown lists and More: http://bit.ly/49kV7vD
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd
How to Manipulate Text in Excel: Split, Combine, and Change Case: https://bit.ly/4oPV93l
Lock & Protect Cells, Sheets, and Workbooks in Excel: https://bit.ly/47B9zNx
Excel VBA Automation: Buttons, Macros, and Custom Tasks: https://bit.ly/4oNNYZV

*Social media:*
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/