Hey Guys,
I registered myself onto this forum because this is the last plast where i could think of with people who might could help me with my problem.
I have an excel file with fitness exersices in it. The values could be different after each training. I need an cell where i could typ in the date and after that excel should show me the best results of that specif day. My Excel sheet is looking in the whole table except of only looking at the values corrosponding to the date i entered.
It is possible that someone lift (fitness) 100kg todays for 12 repetitions in 3 sets. I need to see that info. The next day someone could maybe only lift 99.3kg for 11 repetions in 3 sets. So i do not need the max value overall. But the max value of that specific day.
The data is comming from a .csv file and will be updated everyday, so the list will be very long over time with dates.
I tried a lot with arrays, if match, lookups and everything into each other but i cannot get it done. What is the most simple solution some of you could give me?
I hope my angel is onto this forum! :D
(When my file is approved i will add it to this thread)
Bookmarks