*Yogi Anand, D.Eng, P.E.*Google Spreadsheet

*www.energyefficientbuild.com*

*Putting Items In A Column In Reversed Order*

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

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

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

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

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

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

In the following I have provided solution to the problem in a more generalized way

If I'd like to determine the age on a certain date every year such as August 1st, what would that formula be?

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

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

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

Google Docs spreadsheet does not support the so called 3-dimensional ranges.

I had a little play with a brute force low-tech solution that would do the job even when sheets are added/deleted/modified as presented in the following:

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

The SORT functions is based on sorting decimlal (base 10) numbers ... so I will use this aspect to sort the column of HEX numbers.

Google Spreadsheet

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

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

Count the number of words and sentences

How do I count the number of:

1. characters without spaces;

2. words;

3. sentences

in a cell containing a string?

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

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

If I understand it correctly, your concatenated data is in column A

So in column B, I extract the numerical data from column A

Then using thhe data in columns A and B I make the PIE Chart as presented in Sheet1

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

Here is a picture of Sheet1 which houses the database Table of volunteers information and HoursWorked

and here is a picture of Sheet2 that captures the LastSubmitted volunteer UserName submitted via the website, and then runs a query to extracts the TotalHoursWorked by the volunteer

Volunteer will have to SUBMIT his/her name via the following Form:

and the hours worked by the volunteer will be displayed as presented in the following:

Sheet1 |

and here is a picture of Sheet2 that captures the LastSubmitted volunteer UserName submitted via the website, and then runs a query to extracts the TotalHoursWorked by the volunteer

Sheet2 |

Volunteer will have to SUBMIT his/her name via the following Form:

and the hours worked by the volunteer will be displayed as presented in the following:

UPDATED JUL-13-2016 ... added Sheet2_MultiLineBulletedItems

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

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

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

DAYS360 function is based on there being 30 days in each of the 12 months in a year ... so it should not be used to count the number of days between two dates.

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

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

Song Collection is in Sheet1

PlayList and the associated Time for songs in PlayList is in Sheet2

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

In Sheet1 street addresses are

update:

I have added Sheet1a where street addresses are

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

In Sheet1 I have created a formula per garyoh's specification

in Sheet2 I present a more generalized formula using row numbers in column A

BeFunk said:

count how many time various words show up in a column and assigne each word a cell with the total.

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

in the following, I have words in column A starting with row 2 down,

list of unique words in column B starting with row 2 down

in column C starting with row 2 down, I have the number of times each word occurs in column A

and the total count of all the words in column A is in cell C1

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

Karen, the ResponseTable in the spreadsheet maintains the order in which the questions were originally created and that order can not be changed. However, you can create another sheet like I did in the following where I used the QUERY function to order the question in the right order of interest to me. As more responses are looged in Sheet1, the questions with their respective answers are automatically created in the order of interest in Sheet2.

I'm publishing the chart itself, using the "image" option. While the chart takes up most of the page when editing, the published image is aroung 600x400 pixels.

Is there any way to increase the size?

When

following is the code that was produced by Clicking on the top left hand corner of the Chart to

to facilitate having control over the width and the height of the Chart published as Image, I moified the code by adding the width and height parameters -- the modified code is hown below without the opening and the closing brackets ...

and finally here is the Chart with the height and width as specified

and here is an image of part of Sheet1

In Sheet1 I have sorted an ItemList of WeekDays Per CustomSortList consisting of

sun

mon

tue

wed

thu

fri

sat

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

In Sheet2 I have applied the formulation in Sheet1 to an ItemList of Names per specified CustomSortList

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

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

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

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

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

Thanks Yogi, This worked.. This is exactly how I wanted and one more small request.. How to have it start from n+2 row(this way I will have a empty row between the entries).

I have added some more formulas in yogi_Sheet1, and yogi_Sheet1a; I have modified the formula in yogi_Sheet2b, and I have added yogi_Sheet2c.

Google spreadsheet does not have a built-in feature to highlight an entire row. However, my workaround presented in Sheet2d might be of some interest to you.

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

So you need an array formula for column H

and you also need an arrayformula for column F

as shown in Sheet1 -- Columns F,G, and H with row 1 colored light brown were added subsequent to the creation of the Form questions shown with header rows colored Gray.

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

view of spreadsheet yogi_Skip Columns With The ImportRange Function - SourceData |

I have added Sheet2 for the case where the columns to be Imported are delineated as a comma separated list -- and I have also considered the order in which the data is to be presented for unique columns in the comma separated list.

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

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

In Google Spreadsheet, at least as of now (Jun-01-2011), you can not use formulas for Conditional Formatting. In the following I present a workaround where column B (not the whole row) can be colored Red in entries in column A contain letters a, e, i, o, or u

In Sheet2, I keyed-in the letters of interest in cell B1 ... thus providing a more generalized solution

Subscribe to:
Posts (Atom)