Construct table from selected rows

Discussion in 'Excel' started by tcebob, Nov 21, 2016.

  1. tcebob

    tcebob

    Joined:
    Jun 11, 2011
    Messages:
    14
    Likes Received:
    2
    Excel 16 / Win 10
    I have a worksheet of my pharmacy data, like:
    Name | # | Dose | Date | etc.​
    Just outside of the table I have added a column to check off refills that I need, by entering "x." Next to that are columns to copy needed data for each checked item: Name | #| Date. Formulas in these columns enter the items from the worksheet if the item is checked. The object is to create a drugs shopping list. Typical formula: =IF($N5="x",B5,"").

    This works pretty well but I'd like to condense the resulting table to remove empty lines. What's a good way to do this?
    tcebob
     
    tcebob, Nov 21, 2016
    #1
    1. Advertisements

  2. tcebob

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    8
    A pivot table might work well for this. You can filter the pivot table by the "x" column.
     
    Amy @ German Pearls, Nov 22, 2016
    #2
    1. Advertisements

  3. tcebob

    tcebob

    Joined:
    Jun 11, 2011
    Messages:
    14
    Likes Received:
    2
    Ah. So that's what a pivot table does. I will look it up and try it. Many thanks.
    tcebob
     
    tcebob, Nov 22, 2016
    #3
  4. tcebob

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    24
    Likes Received:
    8
    There are so many ways to use a pivot table - this would be just one.

    Select the range where your information is stored and click insert pivot table. I would use your "x" column as a filter and select only the rows that have an "x". Then I would put your drug name in the rows.

    If you need any help let me know. Once you play around with the pivot table I think you'll really like them - they can make getting information very fast.
    -Amy
     
    Amy @ German Pearls, Nov 22, 2016
    #4
  5. tcebob

    tcebob

    Joined:
    Jun 11, 2011
    Messages:
    14
    Likes Received:
    2
    Thanks again, Amy.
    tcebob
     
    tcebob, Nov 22, 2016
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. baldi
    Replies:
    1
    Views:
    782
    Sohail
    Dec 25, 2014
  2. DanM
    Replies:
    1
    Views:
    374
    XLPadawan
    Jun 13, 2016
  3. Jonny

    Text to Rows

    Jonny, Dec 16, 2014, in forum: Excel
    Replies:
    0
    Views:
    361
    Jonny
    Dec 16, 2014
  4. Martin Sprenz

    Pivot table Days to Months

    Martin Sprenz, Mar 17, 2015, in forum: Excel
    Replies:
    0
    Views:
    252
    Martin Sprenz
    Mar 17, 2015
  5. Lillian Livingston
    Replies:
    0
    Views:
    168
    Lillian Livingston
    Jul 18, 2016
Loading...