The table contains dates, name, and mark.
Similar to Vlookup, I want to select a name, and have the marks for the latest 5 dates be displayed.
Alternately would this be best completed by a formula or a macro?
Example attached
The table contains dates, name, and mark.
Similar to Vlookup, I want to select a name, and have the marks for the latest 5 dates be displayed.
Alternately would this be best completed by a formula or a macro?
Example attached
Here one posible solution
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thanks again popipipo!
In cell D4, use the array formula:
Confirm as an array with Ctrl-Shift-Enter.Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
What about when more dates / data is added?
Another solution.
Is 100 dates enough?
Nope, but from that formula I can adjust it. Thanks popipipo!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks