How to Match Positive Values with Negative Values in excel using Countif Formula(reconciliation)

How to Match Positive Values with Negative Values in excel

The Beginner's Guide to Excel Functions
🛎️ Subscribe To My Channel and Get More Tricks and Tips.

Bank Reconciliation
Balance sheet reconciliation
matching line items
#MsExcelWorld
#reconcilation
#debit
#,credit
#knockoff
#matching positive with negative values
#msexcel
#excel
#microsoftexcel

Download File

Countif Video

Searches
Bank Reconciliation
balance sheet reconciliation
How to knockoff debit and credit values in excel
How to Match Positive Values with Negative Values in excel
How to Match Debit values with Credit values using formula
formula for matching debits and credits in excel
How do I use debit and credit to match in Excel?
How do I combine a debit and credit column in Excel?
What is the formula of debit and credit?
How do I filter credit and debit in Excel?
Debits and Credits to offset in a column
Formula to Match Debit & credit values
Deleting rows with matching debit and credit criteria
Need to quickly match off debits and credits
I need to match up negative values with corresponding positive value

[helenausoro]

This was really helpful. Had over 1200 numbers to Match, and it worked

[maryproctor]

This was incredibly useful for a large spreadsheet (GL download from one balance sheet nominal code) in which I needed to separate out the 'contra' items. I used 'false' for the contra and the rest was in 'true'. I was able to filter prior year too. Huge gratitude to you.

[curvyfilms]

I cant thank you enough for this video..This made my day very easy..Thanks a lot...

[snowdrop]

Thanks alot.. its amazing.. I get all the contra items in one shot😊😊

[roastingkamaharathi]

Love you bro! You saved my time.
Working perfectly fine

[watcheverything]

I am watching your video...n thx a lot ..this thing saved my time ....tku so much

[subhamjaiswal]

Very useful formula.. thanks for sharing it 🙂

[Allsmort]

Thank you so much I was stuck with this and you solve my problem

[hariprasad]

Very much useful, Thanks a lot for sharing it.

[uroospunyali]

There is no voice at all. I cannot hear you.

[shiba]

Maza aagya yaar awsum life saving hack

[balramsingh]

This is an awesome stuff for absolute match - can i know if the amount after knocking off is within our waive off limit (let's say - 25 USD) ?

[daminibirwadkar]

In this formula how we get less then set off less then 1 amount into false

[AmitKumar-xdyu]

How to identify when amounts are knocking off when they are different figures i.e 100 and -50, -50 suming to zero under check number 101

[noor-e-quran]

Bro How about there 3 same values i.e. +100, -100, -100 how to keep one -100 and knokoff other 2

[phanindrakumarvavilala]

You have to explain the logic why we are using... i am not getting.. but most useful formula... countif we know... but this way didn't use...thanks a lot.. try to improve to tell the logic bro.. second portion i am not getting..

[shashinair]

let me know if you have any what app group for any support

[erikguzik]

CANNOT HEAR Anything, quit watching 2 minutes into the video... sorry.

[AdeinTech]

The volume on this video is way too low