yogi_Compute Column By Column MIN MAX And Corresponding Month For Each Item

Google Spreadsheet   Post  #2162

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

question by jacquespar:

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

Find matching date for min and max value
I want to find the month that matches the min and max values, as per the example:

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

yogi_Pull Row By Row GroupNo For Which Entry in That Row Is The Largest Entry In That Row

Google Spreadsheet   Post  #2161

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-08-2017

question by Hồ Quang Hướng:

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

SUMIFS providing correct values only when I delete&paste the same value

I have used an index/match/max filter to identify column headers of cells with a value greater than zero in a given range. This works fine when there is only one such cell in a range. But what if there are multiple cells with a value greater than zero in a range? Is there a formula I can use to identify all column headers for all cells with values greater than zero in a given range?

yogi_Multi Criteria Summing From Filtered Data

Google Spreadsheet   Post  #2160

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-08-2017

question by maddy:

https://productforums.google.com/forum/#!topic/docs/GSYwdTbjcqw;context-place=mydiscussions
Identify column headers for cells that meet criteria in a range
OK.. cant  figure out why.

for the first condition if I delete and paste the same value i.e., 2 in D1, it returns correct value.

Shouldnt it by default take 2 the first  time itself.

SHEET

**you can take a copy of the tab to test

yogi_Pull Row By Row GroupNos For Which Entries Are Greater Than 0

Google Spreadsheet   Post  #2159

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017

question by CAB05:

https://productforums.google.com/forum/#!topic/docs/UFZB8NZBMAE;context-place=forum/docs
SUMIFS providing correct values only when I delete&paste the same value

I have used an index/match/max filter to identify column headers of cells with a value greater than zero in a given range. This works fine when there is only one such cell in a range. But what if there are multiple cells with a value greater than zero in a range? Is there a formula I can use to identify all column headers for all cells with values greater than zero in a given range?

yogi_Flag With 'S' Row By Row If Time In Column B Plus Duration In Column C Is In Range Of Clock Time In Row 1

Google Spreadsheet   Post  #2158

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017

question by MatKa!#:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/GXVpoAYH2Ro;context-place=mydiscussions

Timesheet creation

 Hello

Im trying to create a timesheet and i need to mark the hours needed for each task with S

So i have the following columns : Name, Task, Time Start and Duration... What i need is, if Time Start is 10:00 and the duration is 3 to feel in with S the hours 10:00 - 13:00

Here is my example sheet for explanation

https://docs.google.com/spreadsheets/d/1dD1ZbSDhprviJ1sO-mtUopOuq-XCyAXD9kzel-GN_Do/edit?usp=sharing

Any help will be appreciated 

Thanks.

yogi_Compute Weekly Stats From Hourly And Daily Data

Google Spreadsheet   Post  #2157

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017

question by KM1388:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/MA6PvQQSGLU;context-place=mydiscussions
Need help on sum and count formula please.
Hi all,

I need some help on sum and count formula for a simple calculation.

=Query(Hours!A:G,"Select A,B, MAX(C),SUM(E),SUM(F), 3*(COUNT(D)+COUNT(F))+sum(G) where A is not null group by A,B",1)

on the formula i use 3*(COUNT(D)+COUNT(F))+sum(G) the result came out null value, if the column G value is null value. you could compare the output on column F and column H with the share link below:

can anyone help please!!!

https://docs.google.com/spreadsheets/d/1ySwvoKx-8WOkc09DGckpaWE_9D_Rp3OPpYzmbKLK0Zw/edit#gid=669098519

Kenneth

yogi_For Each Set Of Customer IDs Select Unique Product Names And Pull Associated Data

Google Spreadsheet   Post  #2156

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-01-2017

question by Jill Dub:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/I8EM7j-I8nE;context-place=mydiscussions
Generate Random List with Multiple Columns Required
I need to randomly generate a list, can be repeating, from a set number of entries - however I need to make sure that the other columns in the entry row also make it in which are data-sensitive. I need to generate the list from entries in Column B, but their corresponding rows in Columns A, C and D also need to be there.

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