yogi_Extract From Sheet1 Into Sheet2 Rows As Specified In Sheet3

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #556    May 23, 2012     www.energyefficientbuild.com.

user RoberA said:
delete a lot of rows by marking
the problem is, that i have a big document where is only every second row are used. now i mark every single row, right-click, 'delete row'. is there a possibilty to mark a lot of rows (every second) together to make it faster?
----------------------------------------------------------------------------------------
in the following generalized proposed solution to the problem, instead of deleting the rows in Sheet1 I have extracted in Sheet2 rows of Sheet1 as specified in Sheet3

yogi_Set Up A Computed Column For AutoNumbering XandRowNumber In The Form Responses Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #555    May 23, 2012     www.energyefficientbuild.com.

MALuisa.Sanchez said:
How to autonumber a column only if row has data on it? (Data came from a form)
Hi everyone ..
We are trying to experiment on google docs before we buy google aps for our business.

This is a link of a spreadsheet we are trying to come up with
https://docs.google.com/spreadsheet/ccc?key=0AryiH8y2wxZtdHhaeXJhR1dFMkJpaDB5LVpzVDBGcEE

 Spreadsheet is filled using a form.. I need to autonumber the rows in order to keep track of items added.  There is already a formula on Column B, but I would like it to NOT AUTONUMBER if the row has not yet been added (or filled)...

Can you make it happen?? pleaseeeeeeeeeeeeeeeeeeeeeeeee

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

following is a solution to the problem

yogi_Setup Table To Enter Start LunchOut LunchIn End Hours In 12 Hour HH:MM Format And Compute Hours Worked In HH:MM

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #554    May 23, 2012     www.energyefficientbuild.com.

user  Sparky Cider said:
Spreadsheet: Tracking working hours (minus the lunch breaks). Also changing the format from 24-hour to 12-hour
Hello,
I currently have a spreadsheet that we are going to use for our business. To give you an idea of our spreadsheet, it has the following fields:
Start (B12)
Lunch Out (C12)
Lunch In (D12)
End (E12)
Now, the employee does not get paid for their lunch break, so we need to minus that from their daily working hours. I would like to use the 12-hour format instead of the 24-hour format. I did see examples how to use the 24-hour format, some that worked -- some that do not work. Also, is it possible to change the input format in spreadsheets? I am trying to locate it but I am having a hard time finding it. For example, you can change this in MS Office, so I am not sure if Google has this capability yet.
For example: If a user inputs 8:00, it automatically changes it to: 8:00:00. Now, I can tell you this will be confusing to some employees, so I would like to dismiss that :00. I would also like to know if we could dismiss military time because employees will most likely not favor this new-improved spreadsheet.
Please advise :-)
------------------------------------------------
following is a solution to the problem

yogi_Concatenate Data From Various Columns Row By Row Per Specification

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #553    May 23, 2012     www.energyefficientbuild.com.

use tabus said:
arrayformula causing trouble 
Hi there,

I've got this problem:

The spreadsheet contains 4 columns where dates (formatted as text, but it must be so) are inserted and the 5th column, where as a result I have the input from columns 1-4, joined together but separated with ";". So it looks like this:

column A       column B     column C     column D                   column E (result)

2012.02.01   2012.02.03   2012.03.01   2012.03.12   2012.02.01;2012.02.03;2012.03.01;2012.03.12

However, the condition is that each of the dates in the result column can be followed by the separator ";" only, when following cell is neither empty nor filled with "nd" text. 

In other words the condition is met only when following cell (within 1-4 column) is filled with the date. So, if only the columns A-B were properly completed, the table would look like this:

column A       column B     column C     column D                   column E (result)

2012.02.01   2012.02.03                                                  2012.02.01;2012.02.03

or:

column A       column B     column C     column D                   column E (result)

2012.02.01         nd                nd               nd                       2012.02.01

Now, the formula I used is as follows:

=if(and(A2<>"";B2<>"nd";B2<>"");A2&";";if(A2<>"";A2;""))&if(and(B2<>"";C2<>"nd";C2<>"");B2&";";if(and(B2<>"";B2<>"nd");B2;""))&if(and(C2<>"";D2<>"nd";D2<>"");C2&";";if(and(C2<>"";C2<>"nd");C2;""))&if(D2<>"nd";D2;"") 

and it works fine, UNTIL "ARRAYFORMULA" IS USED AT THE BEGINNING

=arrayformula(if(and(A2:A<>"";B2:B<>"nd";B2:B<>"");A2:A&";";if(A2:A<>"";A2:A;""))&if(and(B2:B<>"";C2:C<>"nd";C2:C<>"");B2:B&";";if(and(B2:B<>"";B2:B<>"nd");B2:B;""))&if(and(C2:C<>"";D2:D<>"nd";D2:D<>"");C2:C&";";if(and(C2:C<>"";C2:C<>"nd");C2:C;""))&if(D2:D<>"nd";D2:D;""))

Then the table looks like this:

column A       column B     column C     column D                   column E (result)

2012.02.01   2012.02.03   2012.03.01   2012.03.12              2012.02.012012.03.12

So, columns A and D are joined together but without the separator, and columns B-C vanish entirely!

Any ideas what I'm doing wrong and how to fix it?

Thanks in advance:)

Browser - Chrome

OS - Win7 HP x64

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

following is a solution to the problem

yogi_Compute The Number Of Non-Blank Rows In Specified Columns

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #553    May 22, 2012     www.energyefficientbuild.com.

user NYVergara said:
Is it possible to count the number of rows in a given field with only names in the cells? (no numbers) I want a total of cells which have data not empty cells
I have a spreadsheet and would like to count the number of rows used. There are several columns but not all of the rows have data. Example: Column D: I am using row 31 to 50 in Column E: I am using Row 31 to 43 can I get a total in row 51 that tells me how many rows were used in column B  and how many rows were used in column E? Thanks!
----------------------------------------------------------------------------------------------
following is a solution to the problem

yogi_Arrange Address Labels Of Specified Number Of Rows Per Label In One Record Per Row

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #552    May 22, 2012     www.energyefficientbuild.com.

user ginanet812 said:
I want text pasted in a column to actually go across several columns in one row- each line pasting into a new field/cell
I am copying and pasting addresses that are in this format . Is there a way to get the info to spread across columns in one row - each line being the next field when I paste? I have searched help but can't find any answers. Maybe I am using the wrong terminology. 
copying:
Company
17075 Smith st
Big City
CA
92000
Want it to go across in separate cells so I can make labels or sort by field:
Company I 17075 Smith st I Big City I CA I 92000
--------------------------------------------------------------------------------------
following is a solution to the problem

yogi_Workaround For Applying Conditional Formatting When A Cell Value Needs To Be Compared With Value In Another Cell

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #551    May 22, 2012     www.energyefficientbuild.com.

user Scott DK said:
Can you do IF THEN formulas in Google spreadsheets?
I'm trying to compare cell A1 with cell A2.  If A1 is greater it turns red.  If A2 is greater it turns green.  Is this function possible in Google Docs?
-----
The conditional formatting is sort of what I'm looking for but I want it to compare the value of the previous cell.  It looks to me as if I can only compare to a predetermined number that I set.  Is that true?
---------------------------------------------------------------------------------------------

in Google spreadsheet as of now (May-2012) anyway Conditional Formatting can not be applied to a cell by comparing its value to another cell ... the cell value can be compared with a known (predetermined) value only.


So, as a workaround, I can use an adjacent column, saycolumn B wherein I can compare the value of the cells of interest and then apply Conditional Formatting to cells of corresponding rows in column B


as presented in the following solution to the problem