+ Reply to Thread
Results 1 to 2 of 2

Quantity Counting

  1. #1
    Registered User
    Join Date
    03-24-2011
    Location
    Crewe, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Quantity Counting

    Hello,

    appologies if i make a mess of my first post, I've searched all over but have been unable to find the answer

    I'm trying to collate the quantity of a number of different items into one table.

    [CODE]

    ITEM QUANTITY
    APPLE 10
    PEAR 5
    BANNANA 8
    ORANGE 3
    PEAR 3
    APPLE 2


    The data collected by the user will then be collated in a seperate table

    so Apple would equal 10, Orange 3

    Thanks in advance

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Quantity Counting

    Not very clear... it might be the case that you want to use a Pivot Table (general intro. link in my signature)

    It might be an idea to post a sample file which illustrates both what you have and what you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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