Monday, October 31, 2016

yogi_Create Formula For Consecutive Dates Repeated Specified Number Of Times Leaving Specified Number Of Cells Blank

Google Spreadsheet   Post  #2080
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-31-2016
question by: Whitney Lewis:
https://productforums.google.com/forum/#!topic/docs/MIKhgFpAau4;context-place=forum/docs
How to create formulas for consecutive dates in cells?
Hi I have column "B" with date of 10/29/16 entered in cells 510 through 531.

I would like the next set of cells in column "B" 534 through 555 to read next date of 10/30/16

and then continue through the sheet.


Is this formula possible?
------------------------------------------------------------------------------------------------------------------

Sunday, October 30, 2016

yogi_Counts The Number Of Times Each Value In B Appears In Column B for Each Group In A

Google Spreadsheet   Post  #2079
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-30-2016
question by: michaeldon:
https://productforums.google.com/forum/#!topic/docs/uJEi_e2avdw;context-place=forum/docs

How to count number of times the value in each row occurs with arrayformula

ADD A REPLY
Hello All

If I have data like the screen shot, and I want to count the number of times each value in column B appears for a group in column A I can use the formula =countifs(A:A,A1,B:B,B1) and paste it into every cell in Column C.

But what if I want to use an arrayformula? Countifs cannot be used with arrayformula and I have found it impossible to replicate this result using IF or countif
-------------------------------------------------------

Monday, October 17, 2016

yogi_Count Number Of Loans For Loan Officers Listed In Cells A2:A4 From Loan Info In Cells A8:E

Google Spreadsheet   Post  #2078
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-17-2016
question by: David Oziel:
https://productforums.google.com/forum/#!topic/docs/GxLUk8-24sg;context-place=forum/docs
How do I add up numbers in a column if a text string in an adjacent column matches?
I have a list of loans that are assigned to different LOAs and I need to add up the total dollars assigned to them. I need to make sure I only add the dollars assigned to the LOA to their total. How do I do that? I am summarizing their numbers at the top of the sheet.

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

Sunday, October 16, 2016

yogi_Conditionally Format Rows A:F Where For The Same Week Same Cut Or Add Appear In Columns E and F

Google Spreadsheet   Post  #2077
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question by: danielTurvey:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/zqA64BytPJI;context-place=forum/docs
Conditional Formatting Multiple Conditions Help
Howdy friends!

I'm struggling with conditional formatting and could really use some help.

In the table below I want to highlight rows 2 and 4 because the Week is the same and CODE2 appears in both Rows.

WeekCutAdd
16/12AMINIPRG
26/5CODE1CODE2
36/12AMINIJAM
46/5CODE2UNTY

The goal is to highlight instances where the same course is being add or cut for the same week.

Any help would be greatly appreciated!
 - Dan

Here is a link to the sample data:

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

yogi_Conditionally Format Cell A2 If Phrase In Cell A2 Occurs Any Where in Column D of Sheet2

Google Spreadsheet   Post  #2076
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question by: ed.W:
https://productforums.google.com/forum/#!topic/docs/rr8wpBHnnqU;context-place=forum/docs
conditional formatting: highlight cell if the text is contained in a range
It seems like I should be able to use a simple "Find" formula but it's not working.


On Sheet1, I have a list of names. On Sheet2, I have a list of "phrases".

I'd like Sheet1, Column A cells to be highlighted if the contents appear in any of the phrases on Sheet2. I'm looking for  "partial matches", not exact matches.

I thought I could use something simple, like =find(A1,Sheet2!$A:$A) but that gives me an invalid formula error.

Can anyone help?
--------------------------------------------------------------------------------------------------------------------------

yogi_Convert Code in Column E (format 'nnnnnn') To That In Column F (format 'nnn nnn')

Google Spreadsheet   Post  #2075
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question via VCita by: Anil Kothari:
https://mail.google.com/mail/u/0/#inbox/157cc0c08150a9f7
I need to convert Zip Code 360005 to xxx xxx format
-------------------------------------------------------------------------------------


Saturday, October 15, 2016

yogi_List In Cell F5 and Down Dates Of Specified Number (cell F4) Of Specified WeekDays (cell F2)

Google Spreadsheet   Post  #2074
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: Bob Denkers:
https://productforums.google.com/forum/#!topic/docs/miqvBxeBlRM;context-place=forum/docs
what is the formula to show the date of every friday Friday in a column
I want to show a payment that is due every friday. So I want the date of every friday to show up in 1 column
----------------------------------------------------------------------------------------------------------

yogi_Compute In Sheet2 Columns E and F Names And Corresponding Numbers Of Salesmen In Sheet1 Column E

Google Spreadsheet   Post  #2073
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: JoseLazoSDT:
https://docs.google.com/spreadsheets/d/1LvlgvE1K2fJAqy7sRKe7PXmwBS6uOQWEORL41ZxU860/edit#gid=0
How to count number of names in a column then display the results
Can't figure out how to count the number of times a salesperson name comes up in column E on sheet1 then display how many times each individual name is counted on sheet2.

Something like:

EDUARDO E1
GABRIEL G1


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

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

yogi_Compute In Sheet2 Columns E and F Names And Corresponding Numbers Of Salesmen In Sheet1 Column E

Google Spreadsheet   Post  #2073
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: JoseLazoSDT:
https://docs.google.com/spreadsheets/d/1LvlgvE1K2fJAqy7sRKe7PXmwBS6uOQWEORL41ZxU860/edit#gid=0
How to count number of names in a column then display the results
Can't figure out how to count the number of times a salesperson name comes up in column E on sheet1 then display how many times each individual name is counted on sheet2.

Something like:

EDUARDO E1
GABRIEL G1


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

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