Related tags:
resolved + (179)
spreadsheet + (81)
microsoft + (64)
office + (44)
formula + (42)
word + (42)
data + (40)
access + (29)
macro + (29)
database + (28)
spreadsheets + (23)
vba + (23)
software + (21)
chart + (20)
csv + (19)
mac + (19)
statistics + (18)
Merge + (16)
formulas + (15)
formatting + (15)
computer + (14)
charts + (14)
table + (14)
graph + (13)
computers + (13)
Outlook + (13)
PDF + (13)
windows + (13)
Excel2007 + (12)
msoffice + (12)
pivottable + (12)
Function + (11)
macros + (11)
MSExcel + (11)
pivot + (11)
programming + (11)
Math + (10)
html + (10)
format + (10)
columns + (10)
powerpoint + (10)
text + (10)
business + (9)
import + (8)
automation + (8)
microsoftoffice + (8)
osx + (8)
sort + (8)
Time + (8)
visualbasic + (8)
column + (7)
conditionalformatting + (7)
dates + (7)
date + (7)
email + (7)
graphs + (7)
numbers + (7)
scripting + (7)
sorting + (7)
google + (6)


Users that often use this tag:
TheBones (6)
malcommc (5)
zardoz (4)
willnot (4)
Anonymous (4)
anastasiav (3)
goethean (3)
mwhybark (3)
Mr. Justice (3)
keep it tight (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
desjardins (3)
FireStyle (3)
jujube (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
digiFramph (2)
Lentrohamsanin (2)
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)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (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)
pwb503 (2)
Jimbob (2)
jessamyn (2)
dmd (2)
synecdoche (2)
skryche (2)
stupidsexyFlanders (2)

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

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

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

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 [more inside]
posted by complience on Nov 25, 2009 - 4 answers

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

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

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 filter: why wont it let me have header rows below row 1? [more inside]
posted by jak68 on Nov 19, 2009 - 15 answers

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

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? [more inside]
posted by schindyguy on Nov 7, 2009 - 4 answers

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

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

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

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

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

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

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? [more inside]
posted by thisisnotbruce on Oct 20, 2009 - 3 answers

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

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

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

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? [more inside]
posted by willy_dilly on Oct 9, 2009 - 6 answers

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

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 %. [more inside]
posted by thinktwice on Sep 24, 2009 - 2 answers

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

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

Does anyone know how to remove the formatting (for lack of better expression) column borders that accompany text when I paste it from Excel to Word? I've checked both Word & Excel help to no avail, probably because I can't frame the question very well. Thanks.
posted by holdenjordahl on Sep 9, 2009 - 8 answers

This should be super easy to do on Excel, right? [more inside]
posted by water bear on Sep 9, 2009 - 15 answers

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range? [more inside]
posted by DZ-015 on Sep 4, 2009 - 1 answer

Another crazy excel question- I can't promise this won't be my last one. [more inside]
posted by TheBones on Sep 2, 2009 - 8 answers

Excel2007Filter: I want to be able to search information between two things in a single cell in Excel. So a cell may have 4-9 typed in it, but I want that cell to be highlighted if a user searches for 7. Or 4. Or anything between 4 and 9 inclusively. (More details and a screenshot of the spreadsheet inside.) [more inside]
posted by sperose on Sep 2, 2009 - 3 answers

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
posted by SansPoint on Sep 2, 2009 - 5 answers

Excel: How can I decide which cell to apply to a formula, based on the runtime contents of another cell? [more inside]
posted by Flunkie on Aug 30, 2009 - 4 answers

MathFilter, NumericSimplificationFilter, RecursionFilter, ExcelFilter: Where X_1,X_2,...,X_n can be any number, is there a name, simplified series, or equation to describe: (X_1)+(X_1+X_2)+(X_1+X_2+X_3)+...+(X_1+X_2+...+X_n) ? Seriously seriously insane exel implementation question inside. [more inside]
posted by Nanukthedog on Aug 28, 2009 - 16 answers

Another stupid excel question. [more inside]
posted by TheBones on Aug 26, 2009 - 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

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

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

I need to transpose a lot of data in Excel. How can I do it efficiently? [more inside]
posted by bobber on Aug 7, 2009 - 19 answers

Trying to get some modified AVERAGE results in Excel. [more inside]
posted by FatherDagon on Aug 5, 2009 - 5 answers

Can anyone recommend a good book for medium-advanced level vba programming for Excel?
posted by Miss Otis' Egrets on Aug 4, 2009 - 1 answer

ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

What are some affordable alternatives to Tableau for data visualization, plotting, etc? [more inside]
posted by ttyn on Jul 29, 2009 - 4 answers

Question on Excel date format changes- please help hivemind, you are my only hope! [more inside]
posted by TheBones on Jul 22, 2009 - 10 answers

Please help an Excel noob with something extremely simple. [more inside]
posted by turgid dahlia on Jul 21, 2009 - 9 answers

Excel 2007 - How do I stop the scrolling function from jumping to the top/bottom of a cell? This happens using the mouse scroll wheel, when clicking the scroll wheel and moving the mouse (free scroll type of thing), and when using the scroll bars onscreen. [more inside]
posted by Merlin144 on Jul 18, 2009 - 3 answers