Hi,
Have an easy one here, i think... I reiterate the fact that index-match is a weak point for me...
I have columns of raw data that is listed in chronological order, but includes duplicate dates. I want the user to specify a time range (between two dates - inclusive). Then the data that falls between those dates is returned to another column.
I have attached an example with manually calculated values.
If any more info is required, please let me know.
Thank you very much
Please manually populate your expected results in your sample file.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
Yes they are manually calculated in the "Output" columns
Sorry - had not scrolled across!
No worries.. Sometimes I forget I am working on a widescreen monitor lol
Enter array formula in P8 and copy across and down. Format values in Column Q as Dates
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
AlKey, that worked great. Thank you very much.
I do have another request. What if I want an additional criteria?
Therefore. I would like to return data that falls between those dates, but ALSO ONLY if the temperature = "123456".
I have attached another example with manually calculated results.
Thank you for your time.
To get the results you want you would need to change date in Cell L7 to 12/17/2017 then use this formula
Formula:Please Login or Register to view this content.
AlKey,
Ah, right! Didn't catch that.
Thank you very much for your time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks