+ Reply to Thread
Results 1 to 28 of 28

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

Hybrid 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

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

    Hi Marc,

    Really sorry that I was not able to address your doubts. Maybe my skills in VBA/ programming is not adequate and hence am unable to get your point in particular. Let me try my best again.
    1) Sheet in Post #12 is the actual layout of the sheet. I would like the results to appear in Column L (Net Entered)
    2) There are several Credit amounts (Column K) for individual Debit amounts (in Column J) as per sheet in Post#12
    3) For an individual Debit amount in Column J there could be as much as 7 credit amounts (sum) in Column K. However I believe you said this seems unfeasible on an old laptop or on a slow one. Also this probably leads to a Level 7 item on your debit side while you can go up to a maximum of only level 2 in your system.

    I am okay if you are able to give a solution up to level 2 on the debit side. We will do it manually from thereon. So if you can provide a code based on the Sheet in Post #12 it will be helpful.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

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


    Quote Originally Posted by sujit.anusha.uchil View Post
    Also this probably leads to a Level 7 item on your debit side while you can go up to a maximum of only level 2 in your system.
    As I wrote in my previous post I can go now up to level 3 for column Dr as sum, level 4 is so long to combinate …

    Ok, I will fit it - later when I could grab the tests laptop - according to post #12 attachment with an automatic way set to level 3
    but you may change each column level and give the priority to column Cr just using the top columns cells …

+ Reply to 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. 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