Results 1 to 28 of 28

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

Threaded View

sujit.anusha.uchil Knock off Single amounts... 04-01-2020, 03:03 PM
sujit.anusha.uchil Re: Knock off Single amounts... 04-16-2020, 04:17 AM
AliGW Re: Knock off Single amounts... 04-16-2020, 04:21 AM
Marc L Try this … 04-16-2020, 09:48 PM
sujit.anusha.uchil Re: Knock off Single amounts... 04-21-2020, 11:43 AM
alansidman Re: Knock off Single amounts... 04-21-2020, 11:46 AM
sujit.anusha.uchil Re: Knock off Single amounts... 04-23-2020, 04:11 AM
Marc L Re: Knock off Single amounts... 04-21-2020, 12:44 PM
sujit.anusha.uchil Re: Knock off Single amounts... 04-23-2020, 04:15 AM
Marc L Re: Knock off Single amounts... 04-23-2020, 08:00 AM
Marc L I found something in one of... 04-27-2020, 09:45 AM
sujit.anusha.uchil Re: Knock off Single amounts... 04-28-2020, 03:36 AM
Marc L Re: Knock off Single amounts... 04-28-2020, 09:11 AM
sujit.anusha.uchil Re: Knock off Single amounts... 04-28-2020, 10:05 AM
Marc L For example I was asking for... 04-28-2020, 10:43 AM
sujit.anusha.uchil Re: Knock off Single amounts... 04-28-2020, 12:48 PM
Marc L Re: Knock off Single amounts... 04-28-2020, 01:08 PM
sujit.anusha.uchil Re: Knock off Single amounts... 04-29-2020, 04:35 AM
sujit.anusha.uchil Re: Knock off Single amounts... 05-04-2020, 11:39 AM
Marc L Re: Knock off Single amounts... 05-04-2020, 01:19 PM
sujit.anusha.uchil Re: Knock off Single amounts... 05-05-2020, 08:15 AM
Marc L Re: Knock off Single amounts... 05-05-2020, 09:17 AM
Marc L Important note to readers : ... 05-05-2020, 01:44 PM
sujit.anusha.uchil Re: Knock off Single amounts... 05-06-2020, 04:53 AM
Marc L Thanks for the rep' and your... 05-06-2020, 09:29 AM
sujit.anusha.uchil Re: Knock off Single amounts... 05-08-2020, 09:14 AM
Marc L Re: Knock off Single amounts... 05-08-2020, 09:38 AM
sujit.anusha.uchil Re: Knock off Single amounts... 05-16-2020, 04:39 AM
  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1