yogi_Set Up Formula Using INDIRECT Function To Be Dragged Down

                                          Google Spreadsheet   Post  #1452
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-27, 2013
question by rand2002 (http://productforums.google.com/forum/?zx=wke6o1qgwz6q#!category-topic/docs/spreadsheets/z9nczi618hQ)
Dragging the =INDIRECT function down rows
https://docs.google.com/spreadsheet/ccc?key=0Avk95-mFPEf4dFRnSjc4eDVIV1pYT1FUOWVvakFqSlE&usp=sharing

In the above sheet, I had a simple function in column C that compared the changes between column D & E.   it was  =(D2-E2)/D2

Each day I add a column left of D and insert today's data.  Afterwards, I have to adjust column C to find the percentage change between column D & E again (because it adjusted D2 & E2 to E2 & F2 when i add a column left of D).

So today I found the INDIRECT function that wont adjust to E & F when I add a column left of D each day.  It works in the first Row when I add quotes around the cell reference, but I cant copy it down to the next row. 

by the way I cropped the sheet to only a few rows, the original has over 550 rows.

Got to be a short cut right?  Please and Thanks for the help.

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

yogi_For An Entry In Cell A1 LookUp Value In Column 2 Of Virtual Table Made From Table Of Data By User

                                          Google Spreadsheet   Post  #1451
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-27, 2013
question by Jennifer Travlos (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/tSAHJBd7eH0)
Multiple If Then's with multiple conditions

Hi all. I understand the basic concept of an "if then" statement. I'm having an issue with multiple conditions. I have column A that states any number of 1 through 21. In column B I want it to automatically write a percentage:

21 = .1

20 = .09

19 = .08

18 = .07

17 = .06

16 = .05

15 = .04

14 and under = 0

So if A says 21 B would say .1. If A says 13 B would say 0. If A says 18 B would say .07.

Does anyone have an idea how to do this? Hopefully I am writing this clearly.

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

yogi_Return Last 3 Unique Entries From Column A Of Raw_Data And Corresponding Values In # Adjacent Columns To The Right

                                          Google Spreadsheet   Post  #1450
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26, 2013
question by Jaxiu (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/wibFsP5pUw0)
Returning last populated cell and rows adjacent to it, and more...
I have a sheet called "raw_data"
- it has 4 columns with data in them
- only column A always has data in it

I've been using this code to return the last populated cell from row A:

=INDEX(FILTER('raw_data'!A:A;NOT(ISBLANK('raw_data'!A:A)));ROWS(FILTER('raw_data'!A:A;NOT(ISBLANK('raw_data'!A:A)))))

it works like a charm, but I also need data from other columns from the same row,
and I can't use the same code by simply changing the "A:A" because cells in row B, C and D can be null

That's my first problem, the second one is:
I need to return a populated cell before the last one BUT it has to be different than the one that I get from the code above, and also the rows adjacent to it.

I'm sorry if this has been posted before, I tried figuring it out on my own, but I just hit a wall.
Thanks in advance for any help.
---
There you go:

http://docs.google.com/spreadsheet/ccc?key=0AoOeJJd-r16wdDkyY055TG5vOXNMZmN4SmRKQUh5R2c&usp=sharing
-----------------------------------------------------------------------------------------

yogi_Compute Address(es) Of Maximum Values In A Column And Then Offset From Maximum Values To Find Best Teams

                                          Google Spreadsheet   Post  #1449
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26, 2013
question by Paul Kioko (http://productforums.google.com/forum/?zx=wh33mpxca23w#!category-topic/docs/spreadsheets/yZ_6v5HbWtc)
Finding the Row of a max value

I am trying to get an address(cell name) of the max value in a range. So what i have is

=Address(Row(Max(S1:S5)), Column(Max(S1:S5)))

After that i want to do a offset for a different value, but i can't get passed the one above as it says argument must be a range

---

Here is a copy of the spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0AlTJqZKyRi55dFF0MHRnSlo1bk9YaGpHN3N3RFVYUWc&usp=sharing

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

yogi_Use QUERY Function Using Named Ranges For Source Data And Field Name(s)

                                          Google Spreadsheet   Post  #1448
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26, 2013
question by Isai Alvarado (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/urtd8hGGOvk)
Query formulas with cell references HELP
Hi,

If I type =query(PTS," "&E8&" ") 

and E8 has select A,B,C where (A='P' and B<8 and C>=2), the formula works.

However, if E8 has a named range select A,B,C where (A='P' and B<"&csp&" and C>=2), it doesn't recognize the named range.

Is there a way to make the query function recognize the named range csp that is inside E8?

Example spreadsheet: https://docs.google.com/spreadsheets/d/1k_kVqHjI_6oAqARq3zgieMpanfwTZJJIJCfxUqhoxxE/edit#gid=0
-------------------------------------------------------------------------------------------------

yogi_Extract Partial String (ending at .com) From Cells Of One Column To Cells Of Another Columns

                                          Google Spreadsheet   Post  #1447
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-26, 2013
question by Cassidy Price (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/OKEPzLavo8M)
Extract partial string from one cell to another

I want to extract the domain from a list of urls from one column to another. For example;

I want to take this url from column A, e.g.

http://www.philly.com/philly/health/topics/HealthDay683371_20131226_White_House_Extends_Insurance_Enrollment_Deadline_for_Second_Time.html

and extract only the domain name to column B, e.g

http://www.philly.com

So for example, if I have a list of urls in column A:

http://www.philly.com/philly/health/topics/HealthDay683371_20131226_White_House_Extends_Insurance_Enrollment_Deadline_for_Second_Time.html

http://www.cnn.com/2013/12/26/showbiz/doctor-who-christmas-matt-smith-farewell/

http://abcnews.go.com/US/wireStory/friday-power-restored-areas-21337106

I would end up with a list of domains in column B:

www.philly.com

www.cnn.com

abcnews.go.com

Can this be done? I've been trying to figure out a way to use regular expressions to accomplish this but I'm stumped. Thanks for any help!

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

yogi_MultiCell Array Formula For Computing Row By Row Minimum For Entries In Range B5 To H8

                                          Google Spreadsheet   Post  #1446
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-25, 2013
question by QusdT (http://productforums.google.com/forum/?zx=kfloo0schu1p#!category-topic/docs/spreadsheets/83KuHWqzeAQ)
ArrayFormula not continueing - AKA Using the MIN FUNCTION with ARRAYFORMULA
The function I'm trying to perform in an arrayformula is:

=ArrayFormula(IF(COUNT(B5:H5)=7,ROUND(MIN(B5:H5),2),""))

I've seen some alternative solutions instead of using MAX posted by Adam & Yogi with explanations that MAX doesn't work so well in ArrayFormula; so I assume since MIN & MAX are best friends that MIN doesn't get along well with ARRAYFORMULA either.

Although just having the correct formula would be AWESOME. It sure would be nice to have the sections of the formula explained so that I can figure it out on my own for future needs.

Thanks Everyone...I sure do appreciate this forum, I use it regularly!

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