+ Reply to Thread
Results 1 to 3 of 3

Extract List with Formulas

  1. #1
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,063

    Extract List with Formulas

    Hi all, need help to extract list with formulas:

    The following is a chart showing the number of new SKUs and cumulative number of SKUs launched by a company over the months:

    SKUs Chart.png

    What I would like to do is to attach data labels below it showing the name of the new SKUs launched for each month. Please see attached Excel file.

    Thank you.

    Joseph
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Extract List with Formulas

    Please try at F18

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I couldn't figure out how to add space between brand.


    I got it
    Please try at F18

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Bo_Ry; 07-26-2020 at 06:10 AM.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,063

    Re: Extract List with Formulas

    Thank you so much Bo_Ry, you are a real master! Works perfectly in my sample worksheet!

    I have a humble request.

    In my actual worksheet, there is an Index column before the Launch Date column and few more columns in between Launch Date and Brand columns. Is it possible to modify the formula?

    Thank you!

+ 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. [SOLVED] Extract unique sub-list from repeated list based on criteria
    By Mohamed Elgammal in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-30-2019, 11:27 AM
  2. Replies: 6
    Last Post: 07-04-2016, 04:52 PM
  3. Replies: 1
    Last Post: 11-13-2015, 04:07 PM
  4. Replies: 2
    Last Post: 08-17-2015, 10:53 PM
  5. Replies: 7
    Last Post: 01-12-2015, 02:48 PM
  6. Formula to extract a list from an existing list ignoring 0 values
    By weso2k in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-16-2014, 10:18 AM
  7. extract formulas with numbers
    By Boomie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 09:24 PM

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