yogi_Use DropDown List To Query Top Value For The Selected Field

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #749   Sep 15, 2012     www.energyefficientbuild.com.

user DarkXaldin said: (http://productforums.google.com/forum/?zx=rrhxx7lqsbz2#!category-topic/docs/spreadsheets/LQSDvDWqlBA)

Hi, I'm trying to have a drop down list be where you choose what query to run. Let's say that I have a table like this in another sheet:

Code        Product          Total Sales

A              A                   100

B              B                   200

C              C                   300

What I want to do is I put in a drop down list with the options in it like top seller, top product, etc., then when I choose an option, the chosen query will be run on that sheet, displaying the required data. Is this possible?

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

following is a solution to a bit more generalized problem

yogi_Compute Percentage Of Total Hours Worked For Various Departments

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #748   Sep 14, 2012     www.energyefficientbuild.com.

user Dionnes said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!category-topic/docs/spreadsheets/Treoi0TQzso)
Percent hours worked... 
Does anyone know what formulas I need to use on Google docs to calculate the percentage hours worked per each department for a 40 hour work week?  

For instance if I work for 

Emergency Room 5 and a half hours 

Pediatrics for 8 hours 

Billing for 26 and a half hours, how do I calculate the percentage hours I worked for each department?

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

following is a solution to the problem

yogi_Set Up To Divide Column A By Column E Present Results To 1 Decimal Place Blank Out Error Results

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #747   Sep 14, 2012     www.energyefficientbuild.com.

user nicobnicob said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!category-topic/docs/spreadsheets/tgGTJb_2BKg)
Division Array in Google Spreadsheets
Hello everybody.  I'm a moderate user of Google Spreadsheets and am trying to learn more formulas to get a lot more proficient and make my work go quicker!

I write in particular about how I can make a divison array (in this particular instance) but this can extend to other calculations.

Basically, I have my spreadsheet information spaced down the rows - it's the office standard for the information I am using - and every month various coloumns need to be divided with each other down the rows.

For example,  The information I have may be:

A1 ---- 1720             E1 ---- 218                --->             H1 --- 7,9

A3 ---- 658               E3 ---- 593                --->             H3 --- 1,1

A5 ---- 2433             E5 ---- 1029              --->             H5 --- 2,4

I am aware that to get 1720 divided by 218, one would put in H1......  =A1/E1 and enter.....  and etc etc for plus, minus, multiplication.

But is there a way -- in array form, if I'm using the right terminology --  to do such a formula down through the whole rows and along the coloumns so all is calculated on hitting enter?

Say, that A1 (remember, spaced) goes all the way down to A107 (for example) and E1 to E107, likewise.

Excuse my novice ignorance, but is there a way therefore of dividing all this information like the line in blue, A1 -> A107 divided by E1 -> E107 --  reiterating of course that A3 would divide E3 etc etc etc.

Hope I'm clear, I just want to get my head around how spreadsheets perform this function and I'll be set for greater things!

Thank you in advance for all your help!

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

yogi_Sort Entries Of Column B Into Column D In Ascending Order By The Word Beginning With A Specified Letter In Cell C2

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #746   Sep 14, 2012     www.energyefficientbuild.com.

user whebt said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!category-topic/docs/spreadsheets/vkhaIMdALaU)
sorting to start after a specific word
I have a master sheet for our school library that looks like this  Ex:         1:  Hanndler                        

                                                                                                         2:  Hbnndler                

                                                                                                         3:  Retro"s Hanndler              

                                                                                                         4:  Retro"s THanndler             

                                                                                                         5:  Retro"s THbnndler

                                                                                                         6:  The R' Hbnndler

                                                                                                         7:  Retro"s Hbnndler 

                                                                                                         8:  The R' Hcnndler 

All these books have to go onto a sheet labeled H. Now thanx to the forum I have been able to construct a query that will pull all the books onto sheet H but i want to be able to sort them by the first letter after H in order that book #2 the first book that starts with Hb should be right after book #4 which is the last of the Ha

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

following is a solution to the problem

yogi_Compute Dynamic Group Total In Another Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #745   Sep 14, 2012     www.energyefficientbuild.com.

user coderwolf said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!category-topic/docs/spreadsheets/9q9OzbtTaSQ)
dynamic group totaling 
Given a spreadsheet with the following columns: Description, Catagory, Qty Owned, Unit Price.  How can I have a column on a different sheet that will sum all extended prices for the category listed?
----------------------------------------------------------------------------------------
following is a bit more generalized solution to the problem wherein I have computed totals for group of all and select categories by category as well as for the entire group

yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank) Spreadsheet No 2

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #744   Sep 13, 2012     www.energyefficientbuild.com.

I am posting this solution because for the solution I had presented in my earlier blog post:

yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank) 

http://yogi--anand-consulting.blogspot.com/2012/09/yogiusing-dcount-with-criteria-cell.html

the associated spreadsheet is suffering from server error occurritis and I am not sure when it will come back to life

the solution presented in this post is not identical to the one in my prior post ... but it is essentially on the same lines as my earlier post.

yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank)

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #743   Sep 12, 2012     www.energyefficientbuild.com.

user xpegenaute said: (http://productforums.google.com/forum/?zx=556ageg3yj8x#!category-topic/docs/spreadsheets/I-XrCrxh-LU)
DCOUNT: 2ndCritera the cell must be empty, is it possible?
Hi,

I am having this little example with two columns, I want to know how many dinners I need to cook for people who are not member of my group. I thought to do it with DCOUNT, but I don't know how to deal with the empty "MemberNumber" and DCOUNT.

=dcount(J13:K18;"MemberNumber";L23:M24)

Criteria:

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

Activity MemberNumber

Dinner ????

Data

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

MemberNumber Activity

5 Dinner

2 Breakfast

Dinner

3 Breakfast

7 Dinner

Thanks,

Xavi

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

following is a solution to the problem:

the spreadsheet underlying this post  as of Sep-13-2012 is suffering from server error occurritis ... and I am not sure when it will come back to life -- so I have presented essentially the same (but not identical) solution in the following blog post:

yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank) Spreadsheet No 2

http://yogi--anand-consulting.blogspot.com/2012/09/yogiusing-dcount-with-criteria-cell_13.html