Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet
on May 9, 2013 -
20 answers
I need a solution to a pretty simple problem with counting instances of different text phrases in Excel.
[more inside]
posted by clockzero
on Mar 26, 2013 -
8 answers
I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside.
[more inside]
posted by bibbit
on Feb 25, 2013 -
4 answers
I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
[more inside]
posted by FireStyle
on Feb 23, 2013 -
9 answers
I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc.
What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to.
I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.
posted by klangklangston
on Jan 31, 2013 -
8 answers
Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right?
[more inside]
posted by frecklefaerie
on Apr 6, 2012 -
7 answers
I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it?
[more inside]
posted by Servo5678
on Feb 17, 2012 -
5 answers
Excel help needed in calculating times.
I need to calculate and predict times based on fixed distances and a known average speed.
[more inside]
posted by dg
on Jun 28, 2011 -
8 answers
I'm dusting off my rusty Excel skills to try to build an easy-to-use, easily updated very basic payroll spreadsheet for a userbase which is completely unfamiliar with Excel.
[more inside]
posted by nevercalm
on Jun 2, 2011 -
9 answers
Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?
posted by Philby
on Mar 24, 2011 -
5 answers
There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle
on Mar 17, 2011 -
6 answers
Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet?
[more inside]
posted by DrtyBlvd
on Jan 28, 2011 -
7 answers
What's the best way to edit a spreadsheet on my PC from across the room, using a Droid over Bluetooth (not WiFi)?
[more inside]
posted by Alabaster
on Jan 13, 2011 -
3 answers
Microsoft Excel Filter: When I type 0.000, I want the cell to display "0.000" and not "0". How do I stop all of this ridiculous autoformating in Excel for good?
[more inside]
posted by nickerbocker
on Nov 29, 2010 -
23 answers
My very important spreadsheet has become too big to use without excel/calc slowing so much that I want to take an axe to the computer. Help!
[more inside]
posted by pootler
on Oct 22, 2010 -
20 answers
Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros.
[more inside]
posted by mbarryf
on Aug 11, 2010 -
6 answers
Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses.
Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API.
This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program?
Thanks in advance.
posted by watercarrier
on Jul 21, 2010 -
15 answers
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.
[more inside]
posted by beammeup4
on Mar 23, 2010 -
7 answers
In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B?
[more inside]
posted by Philby
on Mar 14, 2010 -
8 answers
I have a massive spreadsheet that's simply too difficult to read, because of its size. Is there any way of making a second spreadsheet that is exactly the same as the first, except that the 2nd's cells just show an "x" if there is information in the 1st's cells. i.e., the 2nd spreadsheet would just show whether or not the cells on the 1st spreadsheet have been filled in, but not the actual information itself. If sheet 1 looks like
this, sheet two should look like
this.
[more inside]
posted by omnigut
on Feb 2, 2010 -
15 answers
I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.
posted by reeddavid
on Dec 29, 2009 -
10 answers
Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.)
[more inside]
posted by malcommc
on Dec 28, 2009 -
5 answers
Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets?
[more inside]
posted by itsonreserve
on Dec 23, 2009 -
7 answers
How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside.
[more inside]
posted by nickerbocker
on Oct 22, 2009 -
10 answers
Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...]
[more inside]
posted by The Deej
on Aug 11, 2009 -
14 answers
I'm looking for a randomized list of every nation state in the world, preferably in spreadsheet column form. Is there anything like this?
posted by billtron
on Jun 29, 2009 -
8 answers
ExcelFilter: I want to calculate an average food spend, but the days I buy food are irregular throughout the month. How can I draw up a table/graph that gives an average based on a date and amount (for OpenOfficeCalc)?
[more inside]
posted by Gisela
on May 21, 2009 -
11 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
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 need to create a database in Excel, with clickable column headers (clicking on them will sort by that column). More inside, of course.
[more inside]
posted by Rubythursday
on Feb 4, 2009 -
7 answers
I need some help finding/creating a Calc/Excel formula that will help me track my breaks at work, depending on how long I work per day.
[more inside]
posted by Solomon
on Dec 18, 2008 -
7 answers
I have a very large MS Excel spreadsheet in Mac Office 2008 (yuk). I want to find every cell that contains bold text and append an asterisk to it -- i.e. "
bold cell text" becomes "bold cell text*". I can probably find a Windows machine if necessary. How can this be done automatically?
posted by beniamino
on Nov 2, 2008 -
4 answers
How do I export email messages from Outlook into Excel (or CSV) while retaining the date/time stamp on each message?
[more inside]
posted by geekgirl397
on Oct 29, 2008 -
4 answers
I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind.
[more inside]
posted by Jackie_Treehorn
on Oct 24, 2008 -
9 answers
How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column?
[more inside]
posted by niles
on Oct 20, 2008 -
7 answers
I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA?
[more inside]
posted by Mokusatsu
on Sep 12, 2008 -
2 answers
I'm a quick learner of computer programs... but am currently looking for a job and am realizing that I need excel training... (another of the things I really should've studied in college.) Any recommendations on where to get training in New York City?
[more inside]
posted by J.R. Benedict
on Jul 31, 2008 -
11 answers
Excel 2007: How do I get "Sum of" out of the data headers of my Pivottable?
[more inside]
posted by skryche
on Jul 28, 2008 -
4 answers
I think I'm going to start tracking my finances using Excel, or maybe Google Docs. This will supplement my credit union's online banking; I've considered Mint, Wesabe, iBank, Moneydance, among others, but haven't been impressed. Info includes date, transaction description, amount, balance, category (withdrawal, deposit, etc.), tags (gas, groceries, etc.) My question: what are your best tips, tricks, and hints for doing this? Excel formulas, creating charts, formatting technique, automation. Anything in that vein would be great. Thanks in advance!
posted by jroybal
on Jul 28, 2008 -
11 answers
