Join 3,433 readers in helping fund MetaFilter (Hide)

847 posts tagged with excel. (View popular tags)
Displaying 301 through 350 of 847. Subscribe:

Related tags:
+ (193)
+ (88)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (30)
+ (30)
+ (25)
+ (24)
+ (22)
+ (22)
+ (21)
+ (20)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
Anonymous (4)
willnot (4)
FireStyle (4)
desjardins (4)
zardoz (4)
SirStan (3)
Jackie_Treehorn (3)
jujube (3)
goethean (3)
skypieces (3)
jefficator (3)
bluejayway (3)
mwhybark (3)
anastasiav (3)
Conrad Cornelius o... (3)
undercoverhuwaaah (3)
stupidsexyFlanders (3)
sdis (3)
foxinthesnow (3)
Mr. Justice (3)
ttyn (3)
corpse (3)
GilloD (3)
keep it tight (3)
apark (3)
Carialle (2)
bluefly (2)
demagogue (2)
bibbit (2)
Irontom (2)
Seeba (2)
Rad_Boy (2)
skryche (2)
thankyoumuchly (2)
synecdoche (2)
Lentrohamsanin (2)
digiFramph (2)
Jimbob (2)
rippersid (2)
furtive (2)
monocultured (2)
jestonb (2)
lea724 (2)
beammeup4 (2)
xedrik (2)
sockpim (2)
pwb503 (2)
nickerbocker (2)
ObscureReferenceMan (2)
crapmatic (2)
pantufla (2)
rorycberger (2)
prunes (2)
ParisParamus (2)
WCityMike (2)
dmd (2)
ewiar (2)
squorch (2)

How does one auto-fill an Excel spreadsheet with terms?

How does one auto-fill an Excel spreadsheet with terms from another data source? [more inside]
posted by Fiasco da Gama on Jul 20, 2010 - 9 answers

Please help me create charts to analyse my self-tacking data.

How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]
posted by razzman on Jul 19, 2010 - 6 answers

Windowing problem in Excel

Windowing problem in Excel. [more inside]
posted by Bruce H. on Jul 14, 2010 - 5 answers

Calculating interest rate

Excel-finance future value help please.... Google Spreadsheet inside. [more inside]
posted by yoyoceramic on Jul 13, 2010 - 4 answers

YTD total based on sum of last number in another row that has a value?

YTD total based on sum of last number in another row that has a value? I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul. I have tried a couple of variations on COUNT, INDEX and OFFSET. Example is here: http://malcommc.com/ytd.xls I am using Excel 2003
posted by malcommc on Jul 12, 2010 - 12 answers

HTML Table to Excel to CSV

I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
posted by jontyjago on Jul 10, 2010 - 7 answers

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

Please help a data analysis amateur!

How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]
posted by BusyBusyBusy on Jul 6, 2010 - 16 answers

There can be only one (Excel formula I have to update)

Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
posted by deludingmyself on Jul 3, 2010 - 7 answers

Copy & pasting from Excel into Word

Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello on Jun 29, 2010 - 5 answers

Excel Merging Rows Help

I have an excel 2007 spreadsheet that has 4,000 rows and 6 columns of information. Need help merging some of the rows together..... [more inside]
posted by bleucube on Jun 23, 2010 - 10 answers

Excel 2003 ... is an update making this product non-functional?

Why doesn't excel 2003 work on my computer anymore? [more inside]
posted by candasartan on Jun 19, 2010 - 6 answers

Correlating dates, times, stock movements

I have lists, in Excel spreadsheets, that contain perhaps 500 rows of data in three columns: Date, Time and Stock Ticker Symbol. I need a method to correlate those three things with unusual stock activity. In other words, if column 1 is March 10, 2010, and column 2 is 10 a.m., and column three is INTC, I need to know if something unusual happened - high volume or big price movement - for INTC around 10 a.m. March 10. Anyone know a program that'll do this?
posted by Flunoid on Jun 17, 2010 - 11 answers

Help me help Word and Excel play nicely together.

I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen on Jun 10, 2010 - 5 answers

Where to find a database of all movies made?

Is there a relatively complete movie database in csv or other Excel-friendly formats? [more inside]
posted by AmitinLA on May 31, 2010 - 3 answers

Save me from having to hire a data enterer.

Bah! Help me deal with my difficult excel data! [more inside]
posted by masterscruffy on May 28, 2010 - 12 answers

Basic and not-so basic excel questions

Excelfilter: Okay, I'm confident that this can be done in Excel, but I don't know how. Basically, I have a set of samples for which a value (size) was measured at various days. I need some formulas to tell me when the first and last values were measured and what those values were (for each sample). [more inside]
posted by kisch mokusch on May 26, 2010 - 9 answers

Have paragraphs. Want just the hyperlinks. In Excel.

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

A text based pivot table

Excel Assist/I don't believe I couldn't figure this one out: I have a table with unique text values. How can I have it act the same way as a pivot table? Sample inside. [more inside]
posted by yoyoceramic on May 17, 2010 - 9 answers

Filtering an Excel Spreadsheet

Problems filtering a large Excel worksheet that resides on a shared drive. [more inside]
posted by rhapsodie on May 17, 2010 - 7 answers

Word I find software that can get to the root of this problem?

How do I obtain a list of all words associated with a list of word roots / stems? [more inside]
posted by hooves on May 13, 2010 - 6 answers

Please help me create a mapping macro?

Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro? [more inside]
posted by jefficator on May 13, 2010 - 4 answers

Can you reccomend me a good Excel 2007 Book?

Can you reccomend me a good Excel 2007 Book? I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel. Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim on May 5, 2010 - 9 answers

Dear Excel 2003, I need my columns back.

A few questions about Excel 2003. [more inside]
posted by Brandon Blatcher on Apr 30, 2010 - 10 answers

Can you help me with an Excel question?

Can you help me with an Excel question? [more inside]
posted by ersatzkat on Apr 22, 2010 - 13 answers

Hey all you apps, quit taking over my function keys!

Clipboard and/or Excel question: How can I assign a function key to do a Ctrl+V paste? [more inside]
posted by crapmatic on Apr 21, 2010 - 3 answers

Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]
posted by mullacc on Apr 18, 2010 - 8 answers

Excel wizardry needed

MS Excel-filter: I want to be able to search for the second occurrence of a word in column A and then pull the corresponding value from column B. More inside. [more inside]
posted by prunes on Apr 16, 2010 - 13 answers

How do I get a CSV file to display properly?

I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
posted by digitalprimate on Apr 13, 2010 - 7 answers

This should be simple in Excel right?

Excel help. In column A I have several thousand numbers. In column B I have several thousand more numbers, some of which are in column A. I would like column C to contain the numbers from column A that are NOT in column B. I would also like column D to contain the numbers from column B that are NOT in column A.
posted by BigVACub on Apr 8, 2010 - 12 answers

Excel for Business?

Quickbooks vs. Excel? My business partner needs some convincing. [more inside]
posted by pakoothefakoo on Apr 6, 2010 - 17 answers

Funnel Charts for Excel 2007?

Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
posted by thankyoumuchly on Apr 1, 2010 - 2 answers

What blogs/books should I read before creating an archival database?

I'm making an archival database (in Excel) with about 10,000 rows and 6-7 columns for each row. I'm doing this so the information will be easy to cross-reference and search. I've never done anything like this before and am looking for books, blogs, etc. for tips, suggestions, and anything that will make my life and this project easier.
posted by melodykramer on Mar 29, 2010 - 16 answers

need help organizing spreadsheet

I need to organize a spreadsheet of log files into specific columns. The spreadsheet is a converted text column, each log file parses things differently, so column 'a' on one row can be userid, while column 'd' on row is the userid. I want to organize this spreadsheet, so that column a is userid for all logs. is there a specific excel formula or macro i should use, i was thinking: if cell contains userid, move to column 'x'. just not sure how to do this. - Tim
posted by fozzie33 on Mar 29, 2010 - 5 answers

Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.

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

Excel Quest

I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row? [more inside]
posted by amethysts on Mar 23, 2010 - 7 answers

CONCATENATE/ CATASTROPHISE

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

Turns out our top referrer is Zombo.com

What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs? [more inside]
posted by wcfields on Mar 10, 2010 - 1 answer

Calling all pairs

Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result? [more inside]
posted by albrecht on Mar 9, 2010 - 11 answers

Excel Noobery

ExcelFilter: I need to write something pretty simple in Excel. I have big spreadsheet of data. Some rows are fill-colored, and some columns are fill-colored. I need something that will show me (hopefully in a table or something) the cells that have their entire column colored AND have their entire row colored. Returning the value of the cell would be helpful too. (I have a feeling this is an embarassingly easy question to answer)
posted by demagogue on Mar 9, 2010 - 5 answers

Help me so I can Wait for it... EXCEL at my job!

Help with Excel 2003... More inside: [more inside]
posted by Mastercheddaar on Mar 9, 2010 - 7 answers

Help me edit named ranges in Excel 2008.

Mac Excel 2008 Question: how can I change the edit mode when defining named ranges? It's not F2, it's not CTRL-U, so what is it? [more inside]
posted by fremen on Mar 8, 2010 - 0 answers

Using Excel Formulas to Rank Ordered Lists

Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Mar 6, 2010 - 8 answers

If I add a percentage to a number, how do I find the original again?

In Excel, adding percentages, needing to correct, and having to get back to the original amount. Can I do this? [more inside]
posted by nevercalm on Mar 6, 2010 - 5 answers

Excel Checkbox Dilemna

Excel Checkbox Question. Please help me write a macro that will selectively uncheck certain boxes within a named range. This has driven me crazy all day today. [more inside]
posted by kev23f on Mar 4, 2010 - 5 answers

Excel: What column does this value appear in?

Excel: How can I find the column that a value appears in? [more inside]
posted by dmd on Mar 2, 2010 - 9 answers

One to Many Renaming & Copying

Looking for a utility to take a single original file, and make multiple copies of that file with different file names, pulled from a list. [more inside]
posted by GJSchaller on Mar 1, 2010 - 7 answers

Using Excel to create the body of an Outlook e-mail

Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that! [more inside]
posted by doh ray mii on Feb 24, 2010 - 1 answer

Excel Filter: Search the contents of one cell for the contents of another cell, then replace with the contents of yet another cell? Is it possible?

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

The cake is not a lie, if we know you deserve it . . .

Excel date puzzle - looking for a simpler solution, ramblings follow [more inside]
posted by protorp on Feb 19, 2010 - 12 answers

Page: 1 ... 3 4 5 6 7 8 9 10 ... 17