yogi_Compute In Columns C And D Row By Row Running Total Of Instances Of 'de' And 'en' In Column B

Google Spreadsheet   Post  #2022

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-15-2016

post by: AndreEG:

https://productforums.google.com/forum/#!topic/docs/xspGQBruyQM;context-place=forum/docs

Need some help with arrayformulas

 I am currently working on my pocket stats, and I would like to have some kind of counter. See the screenshot:

I would like to do the same with arrayformulas, but currentky 'm getting the error "circle reference".

Thanks for your help

Andre

yogi_Pull Name Of Grade Winner Scoring Maximum Number Of Total Points By Specified Grade

Google Spreadsheet   Post  #2021

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2016

post by: Abby Samotis:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-SN-HUxkz8U;context-place=forum/docs
Pulling max from several data points in a sheet.
I have a sheet that records points per grades 7-12 by student name. I would like to pull the name of the student with the most points in a grade and report it in a separate cells. 

Therefore I want to pull the name cell, based on two cells of data: most points, and grade. My end goal is to report the student of each grade 7-12  by name. 

Advice?

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

yogi_Conditionally Format Current Month Column

Google Spreadsheet   Post  #2020

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2016

post by: RyanU:

https://productforums.google.com/forum/#!topic/docs/r_zL4z_jpvw;context-place=mydiscussions
Conditional Formatting for Months

Basically I'm looking to highlight the current month and it's column (subset of cells within that column).

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

yogi_Use Custom Number Format To Display Results That Amount To 0 (or $0.00) As Blanks

Google Spreadsheet   Post  #2019

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2016

post by: Lampasas Trucking:

https://productforums.google.com/forum/#!topic/docs/NAp-GMNpIgs;context-place=forum/docs
Getting rid of the "$0.00" until I input an amount
Hello,

I'm attempting to make invoices for my business, which is cement and crane work. There are times when I do not know the amount of hours the crane will be running, therefore I cannot input the amount due. The guys go out and do all the heavy labor, and prior to them leaving, I must have an invoice for them to go off of. When I do not enter a number of hours, it simply stays at $0.00, which is correct, but then when the customer signs the invoice at the end of the job, lets say it was a 6 hour crane job, the new total of $1065.00 has to be scribbled (handwritten) over the old $0.00. It just looks unprofessional and is annoying. I don't want to delete the formula, because I'm aware that would rid me of the "$0.00". Any help would be appreciated!! Thank you!

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

yogi_Look In DataCase Table And Delineate If Error(s) Are Found Any Where in The Table

Google Spreadsheet   Post  #2018

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-13-2016

post by: Mark Spencer:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/P46JU_s1m84;context-place=mydiscussions
Searching a range for a specific value
I want to test a range for the presence of a specific value, is this possible.

For example, I have a data set containing calculated and non-calculated fields. Some of the calculated fields test for error conditions in data elements in their row and return "ERROR" if met.

I want a separate sheet to test (TRUE/FALSE) for the presence of any errors anywhere in the given range.

Thanks

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

yogi_Rearrange A Table Of Entries Into DataBase Layout

Google Spreadsheet   Post  #2017

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-12-2016

post by: kfeuerhelm:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-_tEugECvM0;context-place=forum/docs
Transpose/Formatting using functions.

I have attached a sample/worksheet:

https://docs.google.com/spreadsheets/d/1yVeViJcuIzEUk3_Gmw5xahtE3fpjqQuKc5n8sqpHEjA/edit?usp=sharing

If you have any ideas let me know.

Thanks!

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

yogi_Sum Up Hours Worked From Weekly Sheets by Customer And Project

Google Spreadsheet   Post  #2016

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-12-2016

post by: tybo611:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/JBj4h7AQuhk;context-place=mydiscussions
SUMPRODUCT/SUMIFS acorss multiple sheets

I'm trying to use the SUMPRODUCT along with SUMIFS to gather data for expended hours across multiple weekly timesheets.  However the formula is only looking at the first sheet, it will not continue through to each subsequent sheet. 

The weekly time sheets are filled out, then the Data tab would pull all that information to track the amount of hours used across the weeks to quickly display any time remaining.

If it could be updated to automatically fill in the Customer and project that would be ideal but that is not a problem currently.

Any help would be much appreciated.  I've attempted this with query as well but couldn't get the syntax correct.

Sample sheet below
https://docs.google.com/spreadsheets/d/11NDNZPrOPANcCl9601cJ0IVRnMSG47hkrBJS_RDRuLI/edit?usp=sharing

All information has been stripped down to non specific, so use of cells/ranges in formula is desired so that it can be quickly updated.

I can get this to work in excel, but for some reason it does not carry over to google sheets. From what I've read, I'm guessing it could have something to do with the array calculations but I'm not sure. 
---------------------------------------------------------------------------------------------