Hi, I've had some great help with learning excel here and hoped I could again!
I have attached a file with the problem...
I need to create a table with the top 14 'ReNo' for each code listed in columns F1-R1. These need to be in chronological order. Also if the code is part of the latest date then that first ReNo. needs to be ignored (since it will not have completed its cycle).
I have had help getting to the formula I have but I can't get it to sort in these ways, so as it is its not working right.
Hope someone can help!
Example3.xlsx
Bookmarks