+ Reply to Thread
Results 1 to 5 of 5

Select single Items from table

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    12

    Select single Items from table

    Hi there,

    I was wondering if it's possible to create a small overview from a bigger list. As shown in the attached spreadsheet, the first small table has some double 'producttypes'. I would like to have an automatic overview from the different producttypes. My normal list is way longer and contains much more different types in way higher quantities. So have a small overview would help me a lot. The second table shows what I would like to see after it works 'automatically'

    Thanks for the Help!!

    Wietse
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Select single Items from table

    You can use PowerQuery (Get&Transform)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-14-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    12

    Re: Select single Items from table

    Thankyou, but I am not allowed to download extra features for excel(not my computer). So you have any other solutions which may work for me?

    Thanks,

    Wietse

  4. #4
    Registered User
    Join Date
    06-24-2016
    Location
    Slovakia
    MS-Off Ver
    MS Office 365
    Posts
    92

    Re: Select single Items from table

    Hi Wietse,

    other option is to use pivot table and adjust it that way so it will show you only types you need..
    Another option is to use advanced filter to get unique list of items.. (how to do it you can find for example here: https://www.youtube.com/watch?v=z_rM...Jxfr0Bq9ElDuTt )

    But I'm not sure if that is "automatic" solution you are looking for.
    Have a fantastic day

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Select single Items from table

    This is built-in feature in Ex 2016 - Get&Transform
    Last edited by sandy666; 02-19-2018 at 01:20 PM.

+ 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] Pivot table- Select only items having two different variables
    By Excel Dumbo in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2013, 07:21 PM
  2. Select all items in pivot table in VBA
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2013, 04:42 AM
  3. Replies: 0
    Last Post: 11-13-2012, 12:53 PM
  4. Pivot Table - Select Multiple Items not ticked
    By noddy in forum Excel General
    Replies: 5
    Last Post: 03-29-2011, 10:54 AM
  5. Select and unselect items in a filter in pivot table
    By TPFKAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2010, 09:39 AM
  6. [SOLVED] Macro - Pivot Table - Select Items
    By S Sainsbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2005, 11:30 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