+ Reply to Thread
Results 1 to 2 of 2

Sort in a series of data with criteria

  1. #1
    Registered User
    Join Date
    04-01-2022
    Location
    dubai
    MS-Off Ver
    2016
    Posts
    2

    Sort in a series of data with criteria

    I have a series of invoices in column B and an SL no. in column A. I have kept the sl no. same for a few invoices to make sumif for other purposes. Now, what my query is, I am trying to get all the invoice nos. separated with a comma in a single cell in the D column. As I type the SL no. in the cell D2, the invoices nos should come in a series of correspondent SL no separated with a comma.
    The example is as below,


    A B C D
    SL INV NO. SL
    1 MOH001 INV NO. IN A SERIES SEPARATED BY COMMA-
    1 MOH002
    1 MOH003
    2 REF009
    2 REF010
    2 REF011
    2 REF012

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Sort in a series of data with criteria

    so we can better see the result you want, are you able to upload a file with some example/sample data, and also highlighted example of the result you are looking for?
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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. Help: Trying to output last data point in series meeting specific criteria
    By MMcCawley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2020, 03:34 AM
  2. [SOLVED] When sorting data the customized series colors don't sort
    By Rhene in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-05-2017, 08:26 AM
  3. Custom Sort Order - Series Data
    By hface119 in forum Excel General
    Replies: 3
    Last Post: 05-25-2016, 07:38 AM
  4. Chart series to only include data that match criteria
    By carl.jones in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-28-2014, 10:14 AM
  5. PivotChart data series/label criteria
    By hradesi1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-05-2012, 04:26 PM
  6. Sort and chart multiple series from raw data using macros
    By RoseyCindy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2008, 05:56 PM
  7. Replies: 6
    Last Post: 05-02-2006, 11:20 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