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?

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

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

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

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.

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

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

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.

	Week	Cut	Add
1	6/12	AMIN	IPRG
2	6/5	CODE1	CODE2
3	6/12	AMIN	IJAM
4	6/5	CODE2	UNTY

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:

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

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

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.

Here's a sample sheet: https://docs.google.com/spreadsheets/d/1IyNGXg3ogHrIzsf_H2eonIHPpOULicG-T5ejPfWFJcU/edit#gid=1917666163

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
-------------------------------------------------------------------------------------

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 E	1
GABRIEL G	1

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 E	1
GABRIEL G	1

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

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