+ Reply to Thread
Results 1 to 16 of 16

Unique from A and sum each row from 3rd Column

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Unique from A and sum each row from 3rd Column

    Hi,

    I am looking for a small and sweet formula that does the work.Existing formula is in A9 with correct result but the current formula seems to be very vast.Is there any alternative to it.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: Unique from A and sum each row from 3rd Column

    One way,

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    Hi, thanx for the reply.Can u explain me what does 'z',x,y represent ?including LAMBDA,REDUCE function here ?

  4. #4
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: Unique from A and sum each row from 3rd Column


  5. #5
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    Ok.Now I am using another function representing above formula as 'f' and using below formula now which is
    LET(f,F10:F12,SORTYBY(f,XMATCH(INDEX(f,,1),TOCOL(Sheet2!D2:D35,1))))
    So how to merge into one single formula.

    Note:F10:F12 is the resulting figure from above attachment.Secondly Sheet2 is not reflected as it is simply using Sortby and it's refrences.
    Last edited by Ekac; 06-13-2024 at 12:38 AM. Reason: Adding additional information

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    Attach an updated workbook, please.

    There is no sheet 2 in the sample attached to post #1.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    Ok I will attach it.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    OK - not there yet.

  9. #9
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    Ok.Kindly find in attachment.

    Two formula 1st is at A9 from above forum contributor & 2nd is at A14.Kindly produce a single formula to get result which is below A14.
    Attached Files Attached Files
    Last edited by Ekac; 06-13-2024 at 01:24 AM.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    Like this:

    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    No,its not like that.You haven't touched Sheet2.

    Pls see first in A15:A17-1st is Orange then Apple then Grapes as per the pattern in Sheet2!D2:D7 whichever do exists in Sheet1 and Grand Total at last if possible.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    I am not your servant - please explain your requirements politely.

    Try this:

    Please Login or Register  to view this content.
    Please REMOVE Office 2021 for your profile if you are asking for 365 solutions.

    If you want solutions to work with 2021 and above, remove 365.

  13. #13
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    I didn't mean to hurt you or any one If it does then I am extremely sorry for that.You all of you are real mentor to me and there are no any other words that I can express it for immense contribution here.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    Just use "please" in your requests.

    Glad to have helped.

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Unique from A and sum each row from 3rd Column

    Please sign off the thread as requested in post #14 - I presume you are now satisfied with the solution?

  16. #16
    Registered User
    Join Date
    06-22-2015
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    75

    Re: Unique from A and sum each row from 3rd Column

    Thank you so much. Yes it has definitely worked.

+ 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. Replies: 2
    Last Post: 04-28-2024, 12:39 AM
  2. For all unique in Column A, return number of unique in another column
    By spot2018 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2018, 12:26 PM
  3. Replies: 2
    Last Post: 11-11-2015, 10:25 AM
  4. Replies: 0
    Last Post: 11-10-2015, 05:59 PM
  5. [SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column
    By HangMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2015, 01:18 PM
  6. [SOLVED] Count unique occurences in one column with unique occurances in another column
    By 21stCenturyLessons in forum Excel General
    Replies: 5
    Last Post: 07-12-2014, 08:44 AM
  7. Replies: 7
    Last Post: 06-27-2014, 02:26 AM

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