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     www.energyefficientbuild.com.   May 18, 2013
user Student Support  (http://productforums.google.com/forum/#!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.
https://docs.google.com/spreadsheet/ccc?key=0AvTqJBK5ZdjNdHh1cFkwcE9xbkJzOFN5cGpFb25pZFE#gid=2

Thanks
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)
http://yogi--anand-consulting.blogspot.com/2013/05/yogipull-select-information-from-table.html

so here we go ...