Results 1 to 5 of 5

How to match Debits and Credits on one column, and then hiding or filtering out

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    California
    MS-Off Ver
    365
    Posts
    3

    Question How to match Debits and Credits on one column, and then hiding or filtering out

    Hi all and thanks for reading this post! :-)

    I have been searching online for Excel answers and can't seem to find a solution.

    I have about 3000 entries of data, of which, has a few debits and credits to zero them out (i.e., they were reclassed to another account).

    I am trying match the debit and credit entries, and possibly hide them or filter them out of viewing. End goal is to focus on the remaining items, without getting lost seeing all the duplicates.

    Any advice would greatly be appreciated!

    Eugene
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Matching debits and credits from one column?
    By nimv1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2020, 08:08 PM
  2. Macro to match Debits and Credits, verifying four columns of each debit and credit match
    By forcedto register in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-22-2016, 05:28 PM
  3. Want to Match Debits and Credits for la ist of Customers
    By Suri159951 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2016, 10:30 AM
  4. way to match 2 or amounts to 1 amount, debits and credits!
    By nimv1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2016, 08:57 PM
  5. [SOLVED] Vba code to match multiple debits and credits by account number
    By TheRock_82 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-12-2015, 05:17 PM
  6. [SOLVED] debits and credits in one column
    By childothe1980s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2013, 03:47 PM
  7. Can't remove debits/credits that match
    By grecon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2010, 04:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1