Closed Thread
Results 1 to 2 of 2

Filter results based on selected date

  1. #1
    Registered User
    Join Date
    07-19-2019
    Location
    Holland
    MS-Off Ver
    Office Proffesional Plus 2016
    Posts
    26

    Filter results based on selected date

    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
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,647

    Re: Filter results based on selected date

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...cted-date.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filter results based on selected date
    By TimBell in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-20-2019, 04:49 AM
  2. [SOLVED] Filter Data Based on What's Selected
    By vill in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-05-2019, 10:00 AM
  3. [SOLVED] Filter results based on cell value and print results
    By MPXJOHN in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-25-2018, 11:38 AM
  4. filter data based on text entered or selected
    By lee2121 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2016, 05:43 AM
  5. [SOLVED] Adding a value to a column based on filter results
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2014, 05:53 AM
  6. [SOLVED] Filter based on selected range
    By forfiett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 05:38 PM
  7. Compare 2 worksheets based on a selected filter
    By oxmanonline in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 08:29 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1