+ Reply to Thread
Results 1 to 3 of 3

Using excel formula to show similar order number with different product

  1. #1
    Registered User
    Join Date
    08-27-2015
    Location
    London
    MS-Off Ver
    MS Excel 2003
    Posts
    6

    Using excel formula to show similar order number with different product

    Hi Guru's,

    I have a 10k++ series of data containing same order number with different product. I want to sort same order number with different product only(example: to show 1001, 1002 & 1003 only)by using excel function but somehow I couldnt get the answer I want. Please help


    Order no. Product
    1001 Toys
    1002 Mee
    1002 Beer
    1003 Chips
    1001 Apple
    1001 Juice
    1003 Jelly
    1007 Coke
    1001 Banana
    1008 Bread
    1009 Chicken

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,904

    Re: Using excel formula to show similar order number with different product

    I think a pivot table will work for you. Use the Order number and then Product as row headers. It might come out looking like:
    1001 Toys
    Apple
    Juice
    1002 Mee
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-02-2018
    Location
    India
    MS-Off Ver
    office 365
    Posts
    20

    Re: Using excel formula to show similar order number with different product

    Use the Pivot Table. Use Product in Rows and order no in Values. Then Sort Order no by smallest to largest. You will get the Result like below.

    Row Labels Sum of Order no.
    Banana 1001
    Toys 1001
    Juice 1001
    Apple 1001
    Beer 1002
    Mee 1002
    Chips 1003
    Jelly 1003
    Coke 1007
    Bread 1008
    Chicken 1009

+ 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] Help function sum product or similar
    By Berna11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2015, 04:57 AM
  2. [SOLVED] Using sum product to show average number of days for closed work orders
    By mmccra2858 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2014, 06:42 AM
  3. Invoicing based on product and order number
    By MOONDRIFT47 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 10:36 AM
  4. [SOLVED] Show date and order number when the userform opens.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-23-2013, 04:50 AM
  5. [SOLVED] 4 digit code for similar product, new product unique code
    By unclejemima in forum Excel General
    Replies: 47
    Last Post: 06-06-2013, 01:02 PM
  6. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  7. Replies: 1
    Last Post: 01-15-2012, 06:53 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