returning desired rows
Results 1 to 2 of 2

Thread: returning desired rows

  1. #1
    New Member
    Join Date
    Feb 2019
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default returning desired rows

    Hi all

    I am fairly experienced with excel and have a moderate degree of visual basic experience, but I am very new to excels query editor. I have a query that contains approximately 36000 records that tracks a work production system. It creates a record every couple of minutes of a production run. My question is this...

    I have a column that counts records, another that has a run number (there may be a hundred records all with the same run number) and other columns that have specific data to that run.

    Is it possible to filter the query so it shows only the final record for each run. So when the run number changes in the run id column, only show the last row entered (for every run). Usually I would work around this with VB, but this file is very large and my works network leaves alot to be desired, so efficiency is key here. I need the file to be much much smaller than it is with 36,000 rows in it.

    Any help would be much appreciated, and any more information can be provided

    Regards and thank you in advance

    Last edited by Fluff; Feb 3rd, 2019 at 10:08 AM.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Post Thanks / Like
    20 Post(s)
    1 Thread(s)

    Default Re: returning desired rows

    try group by run number with max of date
    I know you know but I forgot my Crystal Ball and don't know what you know

    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts