yogi_Apply Conditional Formatting To Cells Of Column D Start And End Row Numbers As Specified And Every Which Row Number As Noted

                      Google Spreadsheet   Post  #1760
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-13-2014
post by markjj:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/MkvhbH0ooKY)
Custom formatting, making it look for the greatest value among several cells

I need custom formatting to look at cells, D5,D7,D9,D11,D13,D15 exclusively and change the formatting of the one that has the highest value or is equal to the one with the highest value.  This should be simple enough but I can't get it to work.  

I've tried GTE, MAX and RANK commands but none are working.
-------------------------------------------------------------------------------------------------------------------

following is the solution to a bit more generalized problem

yogi_Apply Conditional Formatting To Cells D5 D7 D9 D11 D13 And D15 For Max Value In These Cells

                      Google Spreadsheet   Post  #1759
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-13-2014
post by markjj:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/MkvhbH0ooKY)
Custom formatting, making it look for the greatest value among several cells

I need custom formatting to look at cells, D5,D7,D9,D11,D13,D15 exclusively and change the formatting of the one that has the highest value or is equal to the one with the highest value.  This should be simple enough but I can't get it to work.  

I've tried GTE, MAX and RANK commands but none are working.

-----------------------------------------------------------------------------------------------------------------------------

Assuming markjj means Conditional Formatting I have presented a solution in the following

yogi_Compute Maximum Score By Grade Row By Row For Specified Student Number For Each Grade

                      Google Spreadsheet   Post  #1758
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-11-2014
post by Ben Weston:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/P5RfRbdhpjc)
Returning max value from columns with a certain header
I'm having trouble wrapping my head around the issue of how to return the max value from a number of different columns, but only if that column has a specific header.  

Here is an example:

Standard	1	2	1	3	4	1	4	5	6	1	6
Student Code
7788	2	3	2	2	4	1	1	2	1	3	3

So, I want to find out the highest score that a student has received in standard one (highest of any column that has a 1 as a header), then I would have a separate cell that calculates the highest score a student has received in standard 2, and so on. I would then have this repeated for each student which I believe calls for the $ sign in the standard portion.

Desired outputs for:

Standard 1: 3

Standard 2: 3

Standard 3: 2

Standard 4: 4

Standard 5: 2

Standard 6: 3 

I know there has to be a better solution than a crazy complex set of nested if/and statements.

Thanks!!!

----------------------------------------------------------------------------------------

yogi_Compute Row By Number Of Hours Driven By Name From Data In Sheet1 And Create A Chart From Computed Data

                      Google Spreadsheet   Post  #1757
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-07-2014
post by Christopher Derienzo:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/KVzD4dhHVAc)
Use two functions in one cell?
Hello,

Let me start by giving some background of this matter. Our local fire department is transferring from paper to electronic "Driver Sheets". Driver Sheets are what the drivers of the Fire Apparatus use to log everything from name to fuel to mileage to time out and time in (Military Time).

This is my problem:

To have this ultimately work for the department I need the spreadsheet to be able to find the Persons name lets say Billy Jo, and take the out and in times, and subtract them for every time BILLY JO drove an apparatus, and add all of those times up to get a total amount of hours. But nobody else's hours can interfere. Here is an example....

Billy Jo    18:51    19:01
Jimmy Bo   17:08  19:09
Billy Jo     1:45      3:00

What needs to happen is the document needs to find all the Billy Jo's and add up the times he has and then give a total amount of hours with out Jimmy Bo and others' times interfere.

Thank you,

Christopher Derienzo

---

I must truly say thank you for that formula, Yogi! It has now helped me achieve victory against the evil #ERROR message I have been receiving!! I just have one more thing to ask that has been brought to my attention. Would it be possible to have another sheet open with all of the Driver's Names that would automatically add the info together as it was put in, and then show it in the cell next to the person's name?

Example:

Billy Jo  14:01 (time out) 15:01 (time in)

Billy Jo      15:42      17:02

James Bo  17:04     17:55

Kyle Co      23:55     00:10

Now could it take all of Billy Jo's information (how many times his name is listed and his total time, time in subtracted by time out) and put it in a new spreadsheet next to his name? It would have to do the same for every James Bo and Kyle Co, keeping in mind that it will all be in one NEW sheet in the file in per say a chart.

Thanks For all the help so far! And let me know if this is confusing, just tell me what is confusing about it and I will reply with a more in-depth answer for you!

Christopher Derienzo

-----------------------------------------------------------------------------------------------------------------------------------------

yogi_Conditional Formatting For Rows Depending On Entry In Column A

                      Google Spreadsheet   Post  #1756
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-07-2014
post by Carly Mills:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/B0N_93Z14mU)
Conditional Formatting: Set row bg color based on dropdown item, same for column

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

--------------------------------------------------------------------------------------------------------

yogi_Pull Data From Certain Field For WeekNumber Associated With Date in Cell N1

                      Google Spreadsheet   Post  #1754
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-07-2014
post by gbah:
(https://productforums.google.com/forum/#!mydiscussions/docs/badkFo_BXvk)
Query a closed NEW Google Spreadsheet
I am using New Google Spreadsheet, I have migrated my project over from the old sheet.  The problem I have is that when i do a web query to the google sheets the spreadsheet shows nothing.  if the spreadsheet is opened then all is fine.  I am using query visualization (select A, B,) EXAMPLE
---
here it is again i hope is edit version

sample edit

---

so i have been unable to find away to add week number function to a query url unless ip put it in manually.  is there away to place the date in sheet1!N1 and have the query url reference that cell select A,B,C,D,E Where C="sheet1!N1" i have tried tjis approac and all i get is the headers of each selected columns