Sunday, September 7, 2014

yogi_Compile Tasks And Row By Row Corresponding Hours From Various Sites For Specified Name

                      Google Spreadsheet   Post  #1755
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep-07-2014
post by manucnius:

Hi. I use the following formula to pick out a particular name in column F to get a list of fees earned. I would like to expand it so that it looks not just for instances of the name (=B2) in column F, but across a range of 15 or so columns, say from E through to R. Is anyone able to suggest a way of doing this? (So that I get columns A, D and E listed each time a name crops up in any of the columns from E to R.)

=query(Current!A:Z, "select A, D, E where F='"&A2&"' and A>= date """&text(D2,"yyyy-mm-dd")&""" and A<= date """&text(E2,"yyyy-mm-dd")&""" Order by A ",1)

As always, thanks so much for any help offered.

Thanks for your willingness to help again. Here's a link to a dummy sheet which I hope gives a basic idea of what I want to achieve and which I can apply elsewhere.