I need help taming a very long list of numbers into useful tabulated data, in Excel.
[more inside]
posted by 256
on Feb 28, 2013 -
10 answers
I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names.
[more inside]
posted by mammary16
on Jan 18, 2013 -
8 answers
How do I permanently change the colour scheme in Excel (2010) so that I don't keep on going blind due to other people's spreadsheets?
[more inside]
posted by Katemonkey
on Oct 18, 2012 -
16 answers
What Mac program should I use for a chart to keep track of my upcoming job applications? You know how in iTunes, you can see the same music library listed alphabetically by artist, or by album, or by genre, and so on? I'd like to be able to view the same bunch of jobs listed by deadline, or by ad number, or alphabetically by requirements.
[more inside]
posted by Beardman
on Oct 1, 2012 -
9 answers
ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!)
[more inside]
posted by smirkette
on Mar 26, 2012 -
10 answers
How do I become a spreadsheet power user? And do I have to get Excel to do it? (Or can I stick with LibreOffice/Google Docs?)
[more inside]
posted by Busoni
on Nov 19, 2011 -
10 answers
I have a massive Google spreadsheet containing entry info for a small film festival. I need to be able to produce tailored reports from it that only contain need-to-know info, instead of making people look at the master sheet. Is this possible? If not, what online software should I use?
[more inside]
posted by goatdog
on Sep 23, 2011 -
5 answers
I'm an artist. Please help me find a day job that makes use of my bizarre love of spreadsheets.
[more inside]
posted by HeroZero
on May 15, 2011 -
8 answers
How can I edit/alter a friend's Google Spreadsheet Form so I can put my own answer in required list items?
[more inside]
posted by gryftir
on Apr 13, 2011 -
2 answers
Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date.
[more inside]
posted by TeachTheDead
on Mar 25, 2011 -
9 answers
I need to slap together a website FAST that contains a map and a (sortable? filterable?) list of Wisconsin-related protest/rally events. I'd really, really like it if people could enter their own events and they'd show up on the map without a lot of intervention on my part.
[more inside]
posted by desjardins
on Mar 10, 2011 -
11 answers
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel?
[more inside]
posted by randomname25
on May 19, 2010 -
10 answers
I need to search the text in column A for the text in column B, replace it with the text in column C, and return the new complete string to column D. I've Googled. I've read. I've cried. Can you please help me?
[more inside]
posted by Salient
on Feb 24, 2010 -
5 answers
I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily?
[more inside]
posted by soulbarn
on Aug 12, 2009 -
3 answers
I need to merge two Excel sheets with some common fields, but the most advanced formula I've ever used is Autosum.
[more inside]
posted by thebazilist
on Jul 7, 2009 -
9 answers
I have hundreds of text strings entered through a form in a Google Spreadsheets which look like
4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front
=4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one.
How can I make Google Spreadsheets interpret this string as a formula?
[more inside]
posted by Akeem
on Mar 12, 2009 -
3 answers
My Google spreadsheet collapsed itself in the middle somehow. How do I get it back?
[more inside]
posted by mathowie
on Feb 5, 2009 -
5 answers
Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know.
[more inside]
posted by guptaxpn
on Feb 5, 2009 -
6 answers
I want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003.
[more inside]
posted by Jacqueline
on Oct 7, 2008 -
1 answer
ExcelFilter: How can I create a spreadsheet that automatically copies a certain type of cell from one column to another?
[more inside]
posted by CXImran
on Sep 26, 2008 -
7 answers
I am looking for a way to sort embedded Google Spreadsheets. I am not looking for advanced features or interacting with the data, but ONLY client side sorting.
[more inside]
posted by joemako
on Aug 11, 2008 -
2 answers
How can a new company track leads submitted via its website through the sales and post-sales process, simply, automatically, and online?
[more inside]
posted by prophetsearcher
on Jan 30, 2008 -
12 answers
Looking for open source spreadsheet templates I can use commercially (if it comes to that) for recipes, fitness programs and the like. Why? Because my excel skills suck.
[more inside]
posted by cameron.case
on Dec 18, 2007 -
5 answers
What kind of software can I use to keep track of information on each client and/or project that I'm working on?
[more inside]
posted by iguanapolitico
on Apr 24, 2007 -
7 answers
How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like
this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row.
[more inside]
posted by bokinney
on Mar 12, 2007 -
7 answers
Well, the people at iRows are shutting down their service at the end of the year and I need to find a way to share my spreadsheets with other people. As usual, there are some problems
[more inside]
posted by killa62
on Nov 15, 2006 -
8 answers
What kind of jobs exist for people who think about numbers and money from a consumer perspective, in a weirdly logical and obsessive way?
[more inside]
posted by croutonsupafreak
on Sep 11, 2006 -
18 answers
I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste?
[more inside]
posted by Happydaz
on Jul 4, 2005 -
6 answers
ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)]
[more inside]
posted by mwhybark
on Sep 29, 2004 -
8 answers
Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.
One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.
The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.
Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto
on May 11, 2004 -
1 answer
I've been thinking about plunking down the cash to buy a licensed copy of MS Office (or Office XP, or Office 2003, etc.) for my new laptop. Can anyone tell me why I shouldn't just run Openoffice instead? From what I've read, it appears that I can "save as" most MS formats with it. Any firsthand experience?
posted by trharlan
on Feb 23, 2004 -
19 answers
I'm working with an alphabetical list of email addresses in Excel, approx. 8500 addresses long. Is there any quick way to remove duplicates outside of manually scrolling through and deleting them by hand?
posted by rocketman
on Jan 7, 2004 -
7 answers
