Hi
I have several different values for every day of the year (I called this the long sheet) columns as follows
today's date ---- value a ---- value b --- value c
Making a graph of this all isn't helpful. It doesn't show the level of detail I need.
I am more interested in +/- 28 days from today.(I call this the focus sheet)
How can I find today's value and pull out the corresponding values a/b/c from the long sheet and out them on the focus sheet?
Many thanks
Bookmarks