What's the right tool for this job in Google Spreadsheets?

Posted by Daniel Harvey on Stack Overflow See other posts from Stack Overflow or by Daniel Harvey
Published on 2010-03-14T16:56:32Z Indexed on 2010/03/14 18:05 UTC
Read the original article Hit count: 246

Filed under:

google-docs

|

spreadsheets

|

google-spreadsheet

Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs?

I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose them to another sheet within the same spreadsheet, check for duplicates and ignore capitals, etc. Is there a way to do this?

© Stack Overflow or respective owner

Related posts about google-docs

Remove 'Google Chrome' folder on Google Docs

as seen on Super User - Search for 'Super User'
I used to sync my Chrome bookmark, and Chrome create a folder named Google Chrome in my Google Docs Now I want to delete it. Is there any way to do? >>> More
Alternative to google docs?

as seen on Super User - Search for 'Super User'
Any alternative that you know? Because google docs really sucks, it wont let you upload powerpoint or any document file which is higher than 3 mb. Please, thanks in advance. >>> More
Direct URL to a Google docs revision

as seen on Super User - Search for 'Super User'
I have a Google doc document. Using Edit-File-See Revision History I can see older revisions and go to them. I want to give some-one a URL which points directly to a specific revision of my document which is not the current one. How do I do this? (Note: The link from the revision list does not work… >>> More
Map a GoogleDocs Spreadsheet to a SQL table

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a generalized plan of attack at this problem: Upon saving a spreadsheet in my Google Docs account a SQL 08 table is updated. Or perhaps via spreadsheet's new 'Form' input method. But the overarching goal is letting google docs function as a front-end editor to sql. thx --steve... >>> More
Google Docs as a Drive - Maximum number of images on 200GB account

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, have you upgraded to a Google Docs Premium Account? I'm wondering if that can be used as I'm using S3 at the moment. I'd like to upload images. Do you know if there is there any limit on the number of images I can upload on my 200GB Google Docs account? Thank you ;) >>> More

Related posts about spreadsheets

does google spreadsheets create forms?

as seen on Super User - Search for 'Super User'
after going to this URL: link text i noticed that it is powered by google docs. i didnt know that google docs make online forms as well. does google doc provide the option to make online forms? has anyone had experience doing this? what language are they using to make this thing so scalable? >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
Rapid Planning: Next Generation MRP

as seen on Oracle Blogs - Search for 'Oracle Blogs'
MRP has been a mainstay of manufacturing systems for 40 years. MRP evolved from simple inventory planning systems to become the heart of the MRPII systems which eventually became ERP. While the applications surrounding it have become broader, more sophisticated and web-based, MRP continues to operate… >>> More
Excel - Linking multiple source spreadsheets with variable amounts of rows to a destination spreadsh

as seen on Super User - Search for 'Super User'
I have multiple source spreadsheets, each with a variable number of rows. An example might be one spreadsheet per bank account, with one row for each transaction, with a date and amount. One spreadsheet might have 30 rows, the other 50, and so on. I want to create another spreadsheet which links… >>> More
Access / Excel crossover: Should i attach spreadsheets to records

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I currently have an archaic system of client records that I am trying to improve. For each client i have a directory, in that directory i include a directory for each job. Each job has a spreadsheet that i use to store their personal details, and run calculations and costings specific to their… >>> More