Saturday, May 18, 2013

yogi_Pull From Sheet Named Info Data From Designated Fields For Specified Student Between Specified Dates

                                          Google Spreadsheet   Post  #1196
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 18, 2013
user Student Support  (!category-topic/docs/spreadsheets/how-do-i/desktop/3-Ofy5WzfRk)
Select Col by a range of dates

Attaching onto a previous question. I am able to customize student data based on a users entry of "x". This works and is fully functional. I am trying to have the 'Expected Results' show ONLY dates that fall within ranges entered into cells D5 / D6 (Start Date / End Date)

F4-F9 shows the 'Expected Results' (Yellow Highlight)
F12-F19 shows the 'Current Results' (Red Highlight)
D5 - Start Date (Yellow Highlight)
D6 - End Date (Yellow Highlight)

Here is a copy of the spreadsheet. Please have a look and let me know if you can help.

B lini

this is related to an earlier question asked by StudentSupport for which I had provided a solution in the following blog post:
yogi_Pull Select Information From A Table Based On Specified Fields (Columns)

so here we go ...