yogi_Pull Individula Stats For Entities From Data In Tabs Of Another Spreadsheet

Google Spreadsheet   Post  #2456

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

question by: Joan Tomines
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Hgn2vUJiq-A;context-place=forum/docs
Grabbing of data from one sheet to another.

Hello, Experts!

I need your help again.

I am working on this sheet:

>>> ATAMAI tab of Copy of Team Stats (Joan) (Please see attached image).

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

What we are trying to achieve is, we need to pull up the data depending on the month (in column A13) and the name on row 14.

The data with the stats will be coming from this sheet:

>>> All the tabs in Copy of TRIBE ATAMAI (Joan)

https://docs.google.com/spreadsheets/d/1bMJanT0euyBTbkJP-3M8Ntp9Dq9UrkwB9vf0gjyMVL0/edit?usp=sharing

Kindly check and advise.

Thank you in advance!

- Joan :)

image.png

26 KB

yogi_Compare Two lists and Flag row where data from list 2 appears in list 1

Google Spreadsheet   Post  #2455

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

question by: Mike Wilday (LAPU)
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/PP-mexvj3xk;context-place=mydiscussions

Compare Two lists and Flag row where data from list 2 appears in list 1.

yogi_Compute Row By Row Running Count Of General Service Numbers (column C) And Compute Specific Service Numbers (column D)

Google Spreadsheet   Post  #2454

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

question by: Logan Twidell
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/x7o-9ArDbEk;context-place=mydiscussions
Dynamic cell referencing within an array function

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.

https://gyazo.com/642587ba0bb0eb379569c06a398c0281 

and You can see on the other spread that Rayley is in the Trolls group

https://gyazo.com/6eee8deafa038af9df5c0263ed966b07 

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.

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.

https://gyazo.com/642587ba0bb0eb379569c06a398c0281 

and You can see on the other spread that Rayley is in the Trolls group

https://gyazo.com/6eee8deafa038af9df5c0263ed966b07 

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.

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.