With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
question by: Zachary Chandler https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/GlHJmCTU81Q;context-place=forum/docs Getting more out of auto filling an equation?
question by: Zachary Chandler https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/GlHJmCTU81Q;context-place=forum/docs Getting more out of auto filling an equation? Hi there! I'm trying to format some text, and I've set up what I thought was a simple enough pattern for the autofill to pick up on but sadly no dice. I've got a column of information that is in a certain order and I'm trying to format it into simple rows. What I've got right now looks like this
And I'm trying to make it look like this
I'm using the CONCATENATE() function to add the punctuation, and my formulas for the cells are
This is what I'm using from left to right, the next row has B10, B11, B12, and B13 respectively. I tried filling this row down and it didn't work as I had hoped, I then input it manually for three rows to see if the pattern would click (previous row# + 4)but the results I got were very hit and miss (currently auto filling another row gives B9, B11, B12, B13 which is the right range of data but starts in the wrong place).
How would I go about either getting autofill to just add 4 to the row entry relative to the cell above it? Or, what other functions could I use to describe the behaviour explicitly?
Thanks for your time!
P.S I'm in a computer class with homework that has some seriously tedious data entry aspects and while its taking me more time to figure out how to do it 'smarter' than doing it manually I'm looking at this as learning opportunity to automate future tedious tasks. I tried to google about this issue but didn't pull anything I could use.
question by: Anonymous Gecko https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/kVU2ynMJRGA;context-place=forum/docs How to duplicate a word in a cell located in a whole row of empty cells?
As the title says,
I have a whole row ( Ex. A1 to A10 ) of empty cells. Say there is a Data is cell A5, then A11 has to replicate the word located in the row range (A1 - A10).
The Data can be randomly generated anywhere from A1-A10 (using google form), so the output has to be replicated in A11.
Also the same has to generated below to new responses as well using Array formula.
question by: Paul Katzman https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/KaUHdrshU2Q;context-place=mydiscussions Apply conditional formatting based on string appearing twice inside a cell Hi, I have a table of tests run on a batch of files. Y axis are the specific files, and X axis are the tests. Each test is able to be interpreted in two different ways, and rather than double my number of columns I have the results in a cell on multiple lines inside the cell. See below for crappy ASCII diagram.
File 1 Result A
File 2 Result A
File 3 Result A
What I'm trying to do is to only highlight cells that contain the same string value for both Result A and Result B, I don't care about tests where Result A and Result B are different values. How is this possible?
question by: David Egan https://productforums.google.com/forum/#!topic/docs/Tk3fEOQeHg4;context-place=forum/docs Express a number in Years and Days
On a project I am working on I want to record how old a person was on a given date. Because I have their DOB and the given dates getting the number of days is easy, But I cannot figure out how to turn, for example I would like 11112 to output as "30 years 154 Days"
question by: Tony Cannon https://plus.google.com/102455272676579377322/posts/fdb2C2oFdjD yogi_From Pivot Table Consolidate Data In Another Table On The Same Sheet
I have an issue with a spreadsheet that I'm hoping you can give me some guidance on.
I help run a snooker competition in the summer and one of the statistics gathered is high breaks. Using pivot tables I split the data down into lists based upon the competition the player is in (Mens, 40+, U21, U16, Billiards)
Now, this works fine BUT when someone has multiple breaks worth recording they are listed multiple times, such as
1 John Farrell Republic of Ireland 132
2 John Farrell Republic of Ireland 104
3 Dean Young Scotland 101
4 Michael Judge Northern Ireland 93
I'd prefer to list them as
1 John Farrell Republic of Ireland 132, 104, 62, 47, 43
2 Dean Young Scotland 101
3 Michael Judge Northern Ireland 93, 77, 56, 47, 43
On this way the breaks table is shorter but keeps more names on display
The sample data set that I have complete with pivot table can be found attached. This sheet has the submissions, a pivot table listing the breaks from the Mens competition and a third sheet where I started playing around with UNIQUE and VLOOKUP.
I'm sure it isn't impossible, but I'm drawing a blank and I'm normally pretty good, probably starting off with the wrong base with UNIQUE/VLOOKUP...