+ Reply to Thread
Results 1 to 2 of 2

Getting the different categories from a table.

Hybrid View

  1. #1
    Registered User
    Join Date
    03-22-2008
    Posts
    1

    Getting the different categories from a table.

    Hey guys, I don't really know how to explain this but, yes I would like to get the different headings from a list in a table.

    For example,
    (sheet1) (A1:B11)

    Fruits Number
    Bananas 100
    Apples 200
    Bananas 300
    Mangoes 400
    Peaches 200
    Pineapples 10
    Mangoes 20
    Peaches 30
    Watermellons 3



    I would like to get the different kind of fruits in a separate table, but instead of going through them one by one, I would like to have a formula which actually gets all the headings (excluding the repeated ones).

    Help please!

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Hi,
    Do you just want the unique list of headings or also to have the sum of the numbers?
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ 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