Monday, October 31, 2016

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-31-2016
question by: Whitney Lewis:
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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-30-2016
question by: michaeldon:

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

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-17-2016
question by: David Oziel:
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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question by: danielTurvey:
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:

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

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question by: ed.W:
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')

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016
question via VCita by: Anil Kothari:
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)

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: Bob Denkers:
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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: JoseLazoSDT:
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

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

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: JoseLazoSDT: