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

852 posts tagged with excel. (View popular tags)
Displaying 351 through 400 of 852. Subscribe:

Related tags:
+ (196)
+ (90)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (31)
+ (30)
+ (25)
+ (25)
+ (22)
+ (22)
+ (21)
+ (21)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (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)
willnot (4)
Anonymous (4)
zardoz (4)
desjardins (4)
FireStyle (4)
stupidsexyFlanders (3)
goethean (3)
anastasiav (3)
mwhybark (3)
keep it tight (3)
sdis (3)
Mr. Justice (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
undercoverhuwaaah (3)
jujube (3)
Jackie_Treehorn (3)
skypieces (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
thankyoumuchly (2)
Flunkie (2)
freddymetz (2)
ewiar (2)
bleucube (2)
jestonb (2)
underwater (2)
slavlin (2)
johnstein (2)
beammeup4 (2)
pdb (2)
pantufla (2)
nevercalm (2)
rossination (2)
johngoren (2)
digitalprimate (2)
Classic Diner (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)

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

A graph for all to see.

How do I get an Excel-generated chart onto Facebook? [more inside]
posted by ricochet biscuit on Feb 13, 2010 - 7 answers

Excel rounding of number

Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]
posted by a womble is an active kind of sloth on Feb 13, 2010 - 6 answers

Getting Excel to reconcile two types of data

Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily? [more inside]
posted by Muffy on Feb 12, 2010 - 8 answers

Can you recommend online tutorials for Excel, Word, and MS Access?

Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]
posted by helios410 on Feb 10, 2010 - 8 answers

Standardize my comment size

Is there a way to standardize 'comment' window sizes in Excel?
posted by digiFramph on Feb 10, 2010 - 10 answers

How do I plot a comparison of points to the normal curve in excel?

How do I compare a scatter of points in excel to a normal curve? [more inside]
posted by jefficator on Feb 8, 2010 - 12 answers

Escelfilter: Making a dummy worksheet to simplify display of information?

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

Column-oriented CSV in Python?

Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]
posted by Kadin2048 on Jan 11, 2010 - 13 answers

Another GD excel question

Another, once again, excel question on fill colors [more inside]
posted by TheBones on Jan 5, 2010 - 11 answers

Excel lookup same day different date previous year

Quick Excel help? Need to retrieve this day last year based on date input by user [more inside]
posted by hypersloth on Jan 4, 2010 - 15 answers

How do I bring HTML data into Excel?

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 lookup/match two values and return a third in Excel

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

Blind Spot in my Excel Formula Abilities

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

Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube on Dec 17, 2009 - 15 answers

I've just spent 16 hours on a lab. Never again.

What spreadsheet/graphing software should I use to do physics labs? [more inside]
posted by vogon_poet on Dec 13, 2009 - 18 answers

Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]
posted by JulianDay on Dec 6, 2009 - 7 answers

Need help making an excel formula

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries. [more inside]
posted by FireStyle on Dec 2, 2009 - 4 answers

Type, copy, click, paste, type, copy, click...

I've been manually sending out emails about test results and then entering them into a database - is there a way to automate so part of this process? [more inside]
posted by SNWidget on Dec 2, 2009 - 10 answers

Slow typing in Excel 2008 and unexplained network traffic

Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]
posted by lbergstr on Nov 27, 2009 - 10 answers

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
posted by complience on Nov 25, 2009 - 4 answers

Is it possible to do a global change-style in Excel?

Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]
posted by min on Nov 24, 2009 - 11 answers

Save me from my excel hell

Another GD excel/csv filter [more inside]
posted by TheBones on Nov 20, 2009 - 3 answers

MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

excel gets my goat sometimes

excel filter: why wont it let me have header rows below row 1? [more inside]
posted by jak68 on Nov 19, 2009 - 15 answers

Hide rows in excel if two cells match.

Please help me create an excel macro to hide rows given a certain criteria. [more inside]
posted by onich on Nov 17, 2009 - 9 answers

-6+6*6 = 25. No, that isn't right...

Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out. [more inside]
posted by andrewcilento on Nov 10, 2009 - 8 answers

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse?

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse? [more inside]
posted by schindyguy on Nov 7, 2009 - 4 answers

Excel: Incrementing Formula Row Copied Across Columns

Excel question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2009 - 12 answers

Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 answers

How to return every Nth value in a column in Excel?

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column. [more inside]
posted by malcommc on Oct 26, 2009 - 13 answers

Evaluate the meaning of a string in Excel.

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

Conditional Formula Selection in Excel

How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]
posted by Bugbread on Oct 22, 2009 - 7 answers

A Program to Help Me?

I started a new internship, and I'm wondering if there is some way to automate copying the non-profit information from this website. [more inside]
posted by moonroof on Oct 21, 2009 - 6 answers

Help me with an Excel AVERAGEIFS problem

Excel help with AVERAGEIFS: I need to generate an average figure per row, but the cells to be averaged need to meet two criteria. [more inside]
posted by blahblahblah on Oct 20, 2009 - 5 answers

How can I force Excel 2007 to save as a single html file?

How can I force Excel 2007 to save as a single html file? [more inside]
posted by thisisnotbruce on Oct 20, 2009 - 3 answers

How to set Excel2003 to automaticall include file name and path on printed spreadsheets

How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]
posted by Wroksie on Oct 20, 2009 - 7 answers

Know any good VBA tutorials?

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]
posted by Librarygeek on Oct 19, 2009 - 1 answer

Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

Your chance to help education reform in a third world country

Help! My job requires IT knowledge I don't have. Two questions. [more inside]
posted by Suciu on Oct 12, 2009 - 8 answers

How to merge data from two excel sheets into one?

How to merge data from two excel sheets into one? [more inside]
posted by willy_dilly on Oct 9, 2009 - 6 answers

Need excel formula to calculate the number of days in a date range, if they end within that range

I need a formula to help calculate the number of days as compared to a range. Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range. [more inside]
posted by malcommc on Oct 1, 2009 - 9 answers

Looking to up my presentation skills in NYC

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
posted by kenzi23 on Sep 30, 2009 - 2 answers

Need formula to calculate a lease rate factor from a %.

Need formula to calculate a lease rate factor from a %. [more inside]
posted by thinktwice on Sep 24, 2009 - 2 answers

Help me determine rate of imprement for my players!

I coach a high school soccer team. Each practice we go through a routine which involves repetitions of various skills. The number of repetitions accomplished by a player for each skill is recorded in an excel spreadsheet for ranking purposes. I want to determine the rate of improvement so the players can see their progress and who's improving most. Is there a simple excel function that would help me do this?
posted by TheManticore on Sep 19, 2009 - 2 answers

Excel column matching

How to remove content from table that is not in other column [more inside]
posted by tseo on Sep 18, 2009 - 4 answers

Page: 1 ... 4 5 6 7 8 9 10 11 ... 18