Is there an off-the-shelf MSExcel function or 2.0 tool that will allow me to "return" a US City/State based on 5-digit US postal codes. I have 160 postal code queries to perform. The postal code data is in MSExcel. Something like
this. I do not have MSAccess and I am a Mac user.
posted by jeffmac
on Jul 4, 2012 -
9 answers
Excel-filter: Is there a way to copy a formula from a cell on one sheet (e.g., page 4) to a different cell on a different sheet (page 1), where the total from page 4 is carried over to page 1?
[more inside]
posted by headnsouth
on Oct 13, 2011 -
16 answers
Recommendations for an online Excel refresher course, preferably free, that will make me an Excel
God Master Wizard user compentant enough not to embarrass myself in 72 hours?
[more inside]
posted by Mitheral
on Sep 29, 2011 -
7 answers
MS Excel gurus: I am looking for a way to export the data from a spreadsheet so that it can be displayed in a Word document as text, with the column-headers as lead-ins for each cell of data. Basically I want to turn
this into
this.
[more inside]
posted by Ike_Arumba
on Apr 6, 2010 -
8 answers
I have a column of around 100 equations that can only be solved with solver in Excel.
Is there any way to create a macro for this purpose. The layout of the spreadsheet given below.
[more inside]
posted by Lucubrator
on Nov 1, 2009 -
3 answers
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading.
[more inside]
posted by cheeken
on Feb 5, 2009 -
14 answers
MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today?
[more inside]
posted by Rock Steady
on Nov 14, 2008 -
13 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
MS Excel question: Creating a master spreadsheet that dynamically updates when information is updated from any one of six other spreadsheets. Possible?
[more inside]
posted by Diskeater
on Jan 13, 2008 -
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
I'm looking for a good, but very basic Excel tutorial. I'm somewhat familar with computers at large, but suddenly faced with an office productivity application my eyes are rolling up in my head and I'm drooling liberally.
[more inside]
posted by elwoodwiles
on Jul 10, 2004 -
2 answers
ExcelFilter: I want to determine if a given value is in a range of cells. A simple true/false evaluation would be sufficient, though returning a reference to the cell might be nice.
posted by namespan
on Jun 3, 2004 -
4 answers
