Friday, December 9, 2016

yogi_Pull From Sheet1 Data Only For Home And Away Teams That Are flagged With 'x'

Google Spreadsheet   Post  #2093
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-09-2016
question by:Aric K:
https://productforums.google.com/forum/#!topic/docs/fBGgRCXyc8I;context-place=mydiscussions
Looking for Help Filtering Data by Linking the Filtering Action to a Cell's Criteria
I'm looking to filter specific data out of a table when I mark an "x" in a cell.  For instance, if I have a list of names as shown below, I would like to enter an "x" in the cell, which would filter out the person's name from my table.  Any suggestions?  Thank you in advance for your help.

xMike
Eric
David
Joseph
Bill
Jennifer
Lisa
Jeff


Calculating Last Month's Income

Monday, December 5, 2016

yogi_From Table of dates And Amounts Compute Lastt Month's Income Average income And Current Month's Income

Google Spreadsheet   Post  #2092
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-05-2016

Calculating Last Month's Income

 I'm trying to dynamically calculate the income for last month. There will continue to be a dynamic data set with new values each month, typically with multiple entries per month so the rows of data will continue to expand. I'm looking for the formula to always sum the total income for the month prior to this current month. 

Additionally, I'm also looking to calculate the historical average monthly income.

I've prepared a mock sheet to illustrate what i'm looking for here: https://docs.google.com/spreadsheets/d/1lx8OT64Dzw0JsoWzOXIDVvX21PePTh0hvhxCXdyUMSc/edit#gid=0

thanks in advance

(side note for anyone looking at this past the month of jan 17, feel free to add new data for the formula to update)


yogi_Check If Names In LIST2 Are In LIST1

Google Spreadsheet   Post  #2091
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-05-2016
a function for checking a list of names against a subset list of names?
Hi! I have a list of names in a spreadsheet, and a smaller second list of names which is a subset of the first. (both in two columns ie first name, surname). I need a function/formula that will simply check each full name in the complete list (ie both columns) to see if it appears in the subset list (which is also in two columns), and if it does, to note that somehow ie put some value/symbol/text in the column next to the name in the complete list. Any tips on which formula/function will do this? [If necessary I can merge the first name/surname columns but I'd rather not.]

Saturday, December 3, 2016

yogi_Compute Sum Of Weekly Hours Every Monday

Google Spreadsheet   Post  #2090
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-03-2016
question by: Ramsey Persing:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!msg/docs/UYB5AZCB-gU/MkedvMdEBgAJ

How to Create a Variable SUM Range Formula

 I'd love some help with a Google Sheet Formula if anyone has any ideas. I make my own hours and I created a simple Google Form to help me track my hours throughout the week. It only asks for the weekday and hours worked that day. The form filters all my answers to a spreadsheet. I'm trying to make a formula that automatically calculates the hours worked for that current week. It looks for the most recent occurrence "Monday", then sums all the hours after that. 

I created a sample sheet  to look at HERE for the data. 

I worked out this to return the address of the cell next to Monday that logs the hours worked that day, but then it won't work when I put that in a SUM formula. Ideas?

=cell("address",index(B4:C11,match("Monday",C4:C11,0),1))

-As a side note, this doesn't search the whole range either. It's only the last 8 entries. That way I don't have two occurrences of Monday. If there's a way to pull only the most recent week that would be nice too. Nor can it just be the last 5 days because some days I work 4 hours in the morning and a more in the evening as in my sample sheet. It's nice to enter my hours right after I work so I don't forget. The only day I couldn't do this is Monday if it's searching for the most recent occurrence.

Thursday, December 1, 2016

yogi_Compute Sum Of Hours In Column B (BeginningTime and EndingTime Separated by '-')

Google Spreadsheet   Post  #2089
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-30-2016
question by: Meg/Ralph:
https://productforums.google.com/forum/#!topic/docs/Ce5zTEX0f8g;context-place=forum/docs
Converting Time
Hi all, I was wondering if there's a formula in Google Sheets that lets me take range of time (for example: 2-4p) and automatically convert that time to express that the project took 2 hours long? Please let me know if that's doable. I also have a sample sheet if that's helpful in anyway? Thank you in advance.

Wednesday, November 30, 2016

yogi_From 'Master Sheet' Pull Select Columns For Specials By Day Of Week And Lunch

Google Spreadsheet   Post  #2088
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-30-2016
question by: Josh Crofts:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/5nfKVHg21pA;context-place=forum/docs

Need to pull data from one sheet into another but also filter it

 Hi,
I am new to the world of spread sheets and am trying to setup some sheets to auto fill off the main sheet.

What I have done is created a master sheet with different categories (venue, address, phone number, day of special etc.)

I would like to be able to pull out the data for each given day onto a new sheet.
This would have Venue, suburb & specials for the given day on each particular sheet.

Some venues do not contain specials for every day of the week so when they are pulled into the monday sheet I have many venues listed with  blank spcials.

I would just like to pull across the relevant venues that have data located in the monday specials column on the master sheet so that when I am on the Monday sheet only venues with specials on Monday are listed.

Here is the required link,

Hopefully that makes sense

Thanks,

Sunday, November 27, 2016

yogi_Populate Required Number of Classes Given Number and Names Of Students And Max Number Of Students Per Class

Google Spreadsheet   Post  #2087
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-27-2016
question by: Andre LaFlamme:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/XGGHbo0tmHM;context-place=mydiscussions
calculating number of classes - please help
I have individual students enrolling for classes with a minimum of 2 and maximum of 8.  As such, 2 or more to 8 is 1 class.  8 is 1 class.  9 is 2 classes of less than 8.  37 students is 4 classes of 8 and 1 class of less than 8.  And so on.  So I will have a cell for individual students, a cell of classes of 8 and a cell for classes of 2 of more and less than 8.  Can someone suggest and efficient way/arrangement of cells and formulas to for me to calculate this?