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     www.energyefficientbuild.com.   Sep-07-2014
post by manucnius:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2pVRZFhLCZ4)

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.

M
---
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.

https://docs.google.com/spreadsheets/d/143fS8JxL-DXcimr-HJO_lfWSTPapuot4LfsKwtt8ttY/edit?usp=sharing
--------------------------------------------------------------------------------------------------------


No comments:

Post a Comment