+ Reply to Thread
Results 1 to 2 of 2

Sort,Filter,Sum Product quantities as categories pack Id,Lot and type

  1. #1
    Forum Contributor
    Join Date
    08-19-2020
    Location
    Dubai
    MS-Off Ver
    Office365
    Posts
    131

    Sort,Filter,Sum Product quantities as categories pack Id,Lot and type

    Hi,


    Required a formula help for summarize the data with a unique list (Sorting,filtering) and return a sum of total qty as categorized list as attached sample.


    Thanks for the help,
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Sort,Filter,Sum Product quantities as categories pack Id,Lot and type

    Not sure what you wish to sum on. Please show us a mocked up solution.

    Please Note
    -------------------
    One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more. Also, uploading an actual file (see yellow banner near the top of this forum's window) showing your data as it exists and on another sheet showing how you want it to look after being processed would help immensely.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Extracting Multi-Pack Quantities
    By jplunkett1 in forum Excel General
    Replies: 1
    Last Post: 12-14-2016, 08:38 PM
  2. Sort a two column list alphabetically by type, then by product
    By fjyoder in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2016, 05:16 PM
  3. [SOLVED] Pack discount based on multiple product units threshold
    By SwissExcel in forum Excel General
    Replies: 4
    Last Post: 11-12-2015, 06:13 AM
  4. [SOLVED] List Unique Product Brands by Product Categories
    By RJK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2015, 03:25 AM
  5. [SOLVED] Sum quantities of product by year
    By relu1979 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-27-2013, 12:47 PM
  6. Macro to filter and sort by multiple categories & Send to correct sheet
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 08:35 PM
  7. Replies: 1
    Last Post: 05-15-2013, 06:55 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