Hello all,
I got a schedule, something like the one below. on another place on the sheet I'd like to collect the data next to the date from the list, that is given in F3
Any suggestions?
HTML Code:
Hello all,
I got a schedule, something like the one below. on another place on the sheet I'd like to collect the data next to the date from the list, that is given in F3
Any suggestions?
HTML Code:
A quick route would be to use either of
a) advanced auto filter
b) Pivot Table
Failing that, assuming each entry in D is unique then you could possibly use formulae such that
and thenPlease Login or Register to view this content.
but as stated either option a or b would be preferable.Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks