Results 1 to 28 of 28

Knock off Single amounts against multiple amount (Similar and dissimilar)

Threaded View

  1. 04-01-2020, 03:03 PM #1
    sujit.anusha.uchil
    sujit.anusha.uchil is offline
    Registered User
    Join Date
    04-01-2020
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    14

    Exclamation Knock off Single amounts against multiple amount (Similar and dissimilar)

    I need a formula to knock off a single amount against multiple amounts so that they net to zero. The amounts are usually netted off against multiple similar amounts for eg. 55,000 against 5 amounts of 11,000 . However they might also be cases where dissimilar amounts might net to zero. Please provide a formula to identify and highlight these amounts. Sample excel sheet attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Subtracting amounts from one column from single amount
    By lavr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2016, 06:39 PM
  2. automatically creating multiple charts with similar layout and put them in a single sheet
    By Celeste84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2013, 12:06 PM
  3. [SOLVED] Generate unique id for similar amounts
    By tanmanoj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2013, 07:19 PM
  4. [SOLVED] Calculating amounts in a single currency from a list of multiple currency amounts
    By Romsky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2013, 12:22 PM
  5. I need to Pull multiple similar data from one single cell and extract into diffrent colums
    By Rapper2nite in forum Excel General
    Replies: 3
    Last Post: 01-30-2013, 07:59 PM
  6. Multiple lines of similar data to one single line
    By T_Van in forum Excel General
    Replies: 7
    Last Post: 02-27-2012, 06:03 PM
  7. Add similar name amounts
    By georgei in forum Excel General
    Replies: 3
    Last Post: 11-05-2009, 10:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1