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

  • Re: last 5 records


    Don't send us an image try to upload your excel file and explain your desired results, click on "Go Advanced" button and find paperclip image button to upload your file

  • Re: last 5 records


    *SOLVED* Also sorry about the image but the information in the file has company information and could not be distributed.

Participate now!

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