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!