last 5 records

  • All,

    I am pretty good with excel but my boss came to me with a problem and I am not sure if it can be done or not. I need your help on this one!

    What I have is a database where parts are tested then entered either pass or fail. If it failed it has a comment as to why and a date. Is there a way to look at the last 5 times a parts was entered by part number and gather any and all comments for those that did fail and display them in one cell.

    I am fine if this requires a macro but I am stumped on this one.

    Thanks for any and all help!

  • Re: last 5 records

    How is the data currently laid out?

    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!