Saturday, May 26, 2018

yogi_Conditionally Format Cells In Column A Which Match The Entry In DropDown List In Cell G6 Or The Group Which They Belong To From Sheet2 - Part2

Google Spreadsheet   Post  #2453

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-26-2018

question by: Krzysztof Czajka
https://productforums.google.com/forum/#!topic/docs/XGupzH6gBac;context-place=mydiscussions
Matching formula
Hi folks!
I try to create timetable and I want to create formula which will help students or them parents to find when they have a class or private lesson.
I will attach link below.
What I want exactly is, if I pick name from List in cell G6 I'd like to that name to be highlighted in all spreadsheet, in addition kid belongs to the different classes/groups, Latvian, Trolls etc and I'd like to be those groups highlighted as well when I pick child name.
Simplyfing if I pick name Amelia in G6 I'd like to highlighted that name and Troll group as she belong to that group as well.
I was able to use match formula, but once I picked name in G6 and it was matching with the name from A column it was highlithing name but in G6 not in A column.
and You can see on the other spread that Rayley is in the Trolls group
so I'd like Trolls and his name to be highlithed.
I hope You will be able to understand. I always try to find out everything on my own but this is difficult for me.
Thanks in advance.

Friday, May 25, 2018

yogi_Array Formula For Sum Of Hours By Student And Date For Entries In Separate Date Sheets

Google Spreadsheet   Post  #2452

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-25-2018

question by: JP1128
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/IHm7O4C7X_k;context-place=forum/docs

SUMIFS in ArrayFormula?

https://docs.google.com/spreadsheets/d/1E5IJET7tgSw3zrgYuDJGMWnMknEytX1jknuphHXKfxU/edit?usp=sharing
Working on Students!

I'm having a problem with the Column D. I need to make it so that when the person's Attend becomes "Y" the sum of the person's hours in the 8/10! would be calculated and returned.

I tried this
=ArrayFormula(SUMIFS('8/10'!$I2:$I,'8/10'!$E2:$E,$A3:$A))

yogi_Conditionally Format Cells In Column A Which Math The Entry In DropDown List In Cell G6

Google Spreadsheet   Post  #2451

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-25-2018

question by: Krzysztof Czajka
https://productforums.google.com/forum/#!topic/docs/XGupzH6gBac;context-place=mydiscussions
Matching formula
Hi folks!
I try to create timetable and I want to create formula which will help students or them parents to find when they have a class or private lesson.
I will attach link below.
What I want exactly is, if I pick name from List in cell G6 I'd like to that name to be highlighted in all spreadsheet, in addition kid belongs to the different classes/groups, Latvian, Trolls etc and I'd like to be those groups highlighted as well when I pick child name.
Simplyfing if I pick name Amelia in G6 I'd like to highlighted that name and Troll group as she belong to that group as well.
I was able to use match formula, but once I picked name in G6 and it was matching with the name from A column it was highlithing name but in G6 not in A column.
and You can see on the other spread that Rayley is in the Trolls group
so I'd like Trolls and his name to be highlithed.
I hope You will be able to understand. I always try to find out everything on my own but this is difficult for me.
Thanks in advance.

Thursday, May 24, 2018

yogi_Conditionally Format Arrival Date If Shipping Date Has Arrived Or Passed

Google Spreadsheet   Post  #2450

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-24-2018

question by: UMuildABook
https://productforums.google.com/forum/#!topic/docs/XGupzH6gBac;context-place=mydiscussions
Conditional Formatting: Is Date X days from Today
I have a column of cells with dates that an order needs to arrive in the customer's hands by.  Next to this cell is the number of days it takes to ship to their location.  I would like the arrival date to be highlighted it is less than the number of ship days away from today.

yogi_Find minimum value in range of duplicates

Google Spreadsheet   Post  #2449

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-24-2018

question by: Paul-Grant Van-Rooyen
https://productforums.google.com/forum/#!topic/docs/8iyQlLwxcxs;context-place=forum/docs

Find minimum value in range of dulicates

Hi there folk,

I am looking for a formula/query to run and find the minimum values in a range that contains duplicates (2 or more). 

The first range which is sorted is in A1:B14 with the required results in D1:E18 (formula required in Cell D2.

The first range which is sorted is in A19:B32 with the required results in D19:E26 (formula required in Cell D20.


Cheers


Wednesday, May 23, 2018

yogi_List Dates For Specified WeekDay Starting From A Given Day For Specified Number Of Weeks

Google Spreadsheet   Post  #2448

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-23-2018

question by: Colin TheWilson
https://productforums.google.com/forum/#!topic/docs/8iyQlLwxcxs;context-place=forum/docs
Increment dates
Hello! I'd like to know a way to increment dates based on the start of the week.

For example, I want to make a series of column headings that say "Week of 5/1", "Week of 5/7", "Week of 5/14", "Week of 5/21", "Week of 5/28".

I'm going to do this on a large scale (A new set of headings every month for many years), so I want to have a function that would only take the month and would auto-generate the week start headings. 

Is something like this possible? Thanks!

Monday, May 14, 2018

yogi_Count Entries For Specified TimeFrames

Google Spreadsheet   Post  #2447

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-11-2018
Sample Sheet

The timestamps are taken from a Google Form, rest of the data redacted for privacy.

I would like to count the number of entries i have in the current month, using 'TODAY()' so the sheet stays updated as the months pass and more form entries are submitted.  I would also like updated totals of the three months and six months including the current month.  I have reworked a formula(I do not understand this formula at all )taken from elsewhere on this forum but it fails when the date range spills over to the previous year.  On the 'Totals' tab, I have my best guess in column B and the expected Values in D. You can see that December returns zero.  I am open to alternative methods, especially if they are simpler/more readable.

Please let me know if there is more information I can provide.  Thanks in advance.