828 posts tagged with excel. (View popular tags)
Displaying 151 through 200 of 828. Subscribe:

Related tags:
+ (188)
+ (86)
+ (67)
+ (48)
+ (47)
+ (45)
+ (44)
+ (33)
+ (30)
+ (30)
+ (24)
+ (23)
+ (22)
+ (21)
+ (20)
+ (20)
+ (20)
+ (18)
+ (16)
+ (16)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
zardoz (4)
willnot (4)
Anonymous (4)
FireStyle (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)
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)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
digitalprimate (2)
Classic Diner (2)
sdis (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)

scraping pdf content?

I have about 4000 pdfs that i need to scrape data from and put into a database. [more inside]
posted by buttercup on Dec 11, 2011 - 8 answers

 

When control-v seems too obvious...

Excel skills required for a particular job… I'm not sure what they are asking for. [more inside]
posted by anonymous on Dec 6, 2011 - 9 answers

Make Excel stop babysitting me.

Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help? [more inside]
posted by ootandaboot on Dec 5, 2011 - 9 answers

Excel for People who don't know anything

Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows. [more inside]
posted by crush-onastick on Dec 2, 2011 - 18 answers

How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?

Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
posted by anewnormal on Nov 30, 2011 - 3 answers

Excel Macros For Dummies

Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct). [more inside]
posted by so much modern time on Nov 30, 2011 - 8 answers

Weighted regression?

Excel statistics question (linear regression with weighted data points) [more inside]
posted by dabug on Nov 30, 2011 - 9 answers

Free online graphing app that plays well with Excel?

Asking for a colleague: "Back in October 2008, I found a free online app that uploaded data from Excel and produced (very pretty) charts and graphs. Unfortunately, I didn’t keep track of the website, and I’m having trouble tracking it down again. Most of the free graphing apps I’ve found online today require that you manually input the data; I’m looking for something that will more easily upload a set of data from Excel."
posted by lassie on Nov 22, 2011 - 5 answers

Can I create pivot table from subset of data?

Can I create pivot table from subset of data? If not, is there another way to do what I want to do? [more inside]
posted by Diablevert on Nov 20, 2011 - 6 answers

Help me become a spreadsheet power user

How do I become a spreadsheet power user? And do I have to get Excel to do it? (Or can I stick with LibreOffice/Google Docs?) [more inside]
posted by Busoni on Nov 19, 2011 - 10 answers

Excel Find and Replace

Excel - Find and Replace -- I use the excel function find and replace often. One spreadsheet finds it instantly. Another searches each cell and takes longer. I stopped updating the instant one before I noticed the effect. Windows xp -- Office 2007 I'd like to have more of the instant search.
posted by notned on Nov 18, 2011 - 8 answers

Excel formula help

Help me write an Excel formula to extract specific data from a list? [more inside]
posted by genesta on Oct 26, 2011 - 8 answers

How to excel?

ExcelFilter: Currently using a clunky nested for loop - is there some way to make this more efficient? [more inside]
posted by hot soup on Oct 25, 2011 - 2 answers

Can this excel sorting macro be made to work on any selected range?

Inside is a recorded excel macro, designed to sort a specific range of cells on a specific worksheet from smallest to largest, from left to right, using the values in a specific range of cells in a row. Is there a way to edit this macro so that it will do the same sort on any selected group of cells on any worksheet? [more inside]
posted by Lentrohamsanin on Oct 20, 2011 - 2 answers

ExcelFilter: Conditional copying between worksheets

ExcelFilter: I'd like to copy the contents of cells from one sheet to another, based on the value of a cell in the first sheet. I'm struggling the proper vocabulary to Google this problem effectively. [more inside]
posted by cramer on Oct 19, 2011 - 8 answers

help me excel at excel

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

Help me find (and change color of) similar data in Excel!

Excel 2007 issue: I'm trying to have Excel mark matching data in two columns with some kind of color or formatting. [more inside]
posted by lattiboy on Oct 10, 2011 - 3 answers

Help me Excel at Excel(tm)

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

help anonymize data

Is there a way to Anonymize various excel columns to protect privacy during a presentation? [more inside]
posted by fozzie33 on Sep 13, 2011 - 5 answers

Shortcut to view list of worksheets in Excel?

I have reason to believe that in Microsoft Excel 2002 (PC) there is a shortcut that makes a menu pop up at the bottom of the worksheet (where the tabs are), that contains a list of all of the sheets in the current workbook, that you can use to go from sheet to sheet. What is the shortcut? [more inside]
posted by periscope on Sep 8, 2011 - 3 answers

Match multiple columns in excel/access

I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
posted by thankyoumuchly on Sep 8, 2011 - 3 answers

How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?

How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]
posted by gibbsjd77 on Sep 2, 2011 - 8 answers

How do I get two different justifications in an Excel cell?

Excel question: I'm making a calendar/schedule in Excel, and I have the dates (numbers) aligned in the bottom right corner. I want to add information and text, though, starting in the top left corner. How do I do this? [more inside]
posted by zardoz on Aug 31, 2011 - 4 answers

Excel function/filtering. Help!

In Excel, how would I do the following: if a cell in a certain column has a duplicate in that column, plus the corresponding cell in that row but another column is blank, delete the whole row? [more inside]
posted by dust.wind.dude on Aug 10, 2011 - 12 answers

Recovering lost data due to text-formatting?

Asking for a friend: I was entering some data into excel and I realized it was changing gene names into dates. E.g. there is a gene in my dataset called SEPT5 and Excel automatically makes this into Sep-05. If I manually set the column as text, it inexplicably changes the cell to a 5-digit number that represents that date, in this case 38596. [more inside]
posted by empath on Aug 10, 2011 - 21 answers

Automatically populate cells in Excel?

How do I get Excel to automatically populate the cell in a certain column when I have manually populated the cells in the other columns of the same row? [more inside]
posted by Flunkie on Aug 7, 2011 - 8 answers

Oh, Loathe is too nice a word...

How can I use a column in an excel sheet to automatically become the comments for a corresponding column? [more inside]
posted by rich on Aug 6, 2011 - 3 answers

Variable view? We don't have no stinkin' variable view.

I know my way around SPSS, but I may shortly be required to do a lot of data analysis using only Excel. Where is the best place for me to learn advanced Excel skills online, with an emphasis on data management and analysis, rather than accounting?
posted by embrangled on Aug 5, 2011 - 5 answers

Panning for email addresses

How do I sort the (potentially) real email addresses from the garbage data in Excel 2003? [more inside]
posted by FatherDagon on Jul 29, 2011 - 4 answers

I have too many conditions for Excel

Using Excel 2000, I need to do conditional formatting with 5 options. This isn't possible with actual conditional formatting, but it is possible using Visual Basic. Unfortunately, I know nothing about Visual Basic. Specifics inside. [more inside]
posted by jeather on Jul 22, 2011 - 23 answers

Line graph of a range of possible rates?

Is there an accepted way to graphically represent rates when small sample data is anonymized? [more inside]
posted by BleachBypass on Jul 21, 2011 - 9 answers

Excel Tables

Link to a table in Excel 2011? [more inside]
posted by alextprice on Jul 11, 2011 - 1 answer

Please help me with an Excel formula.

How can I use Excel to automatically calculate the average of the best two of three results? [more inside]
posted by MighstAllCruckingFighty on Jul 4, 2011 - 10 answers

Excel help needed!

I have a formula for inputting into my expense sheet but it doesn't populate the field like it should. I stole the formula from my time sheet, and that does populat the column for the 4 weeks after I manually put in date 1. It is: =IF($B$4=0,"",SUM(B4+1)) So...why does it work in one sheet but not the next? [more inside]
posted by dash_slot- on Jul 1, 2011 - 7 answers

Saving .csv files in Excel

About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value. [more inside]
posted by Mr_Zero on Jun 30, 2011 - 7 answers

Can I get anything useful out of my savings history?

As a result of my method for saving money, I've ended up with a huge excel spreadsheet for the last 4 years detailing how much I've put in and taken out of my savings account. The problem is that although I've taken time to record all this information, I've now realised that I'm not sure what I can actually do with it. Do you have any ideas? [more inside]
posted by mr_silver on Jun 30, 2011 - 12 answers

Calculating durations and times in Excel

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

Outlook screws up pasted Excel objects

Why does Outlook render spreadsheet data pasted into an email so shittily, and how can I avoid this? [more inside]
posted by goethean on Jun 28, 2011 - 11 answers

I don't think Fortran and punchcards cut it anymore...

Which programming languages are best suited to creating a timetabling application? [more inside]
posted by bister on Jun 26, 2011 - 16 answers

Excel Formula for First Instance of Something in Row, Then Top Value in That Column?

Excel question (debt management/budgeting): what formula gets me the first instance of something in a row, and then how I can pull the date from the top of that column? More inside. [more inside]
posted by WCityMike on Jun 23, 2011 - 8 answers

Does excel have a WHERE clause?

I have an excel file with a list of expenses that are continually updated, sorted by date. There is a column for specifying the category that each expense belongs to. Is it possible to create a formula that adds up the expenses that belong to a specific category? [more inside]
posted by Phire on Jun 21, 2011 - 4 answers

Building the simplest payroll template in Excel. No, really simple.

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

I got 99 problems and Excel isn't one of them.

How do I, using Excel, determine the frequency of orders, the minimum/maximum amount per customer and the average order size? [more inside]
posted by hecho de la basura on May 21, 2011 - 11 answers

The extract range has a missing or illegal field name.

Does anyone have a handly list of reasons why one would get the error "The extract range has a missing or illegal field name." when using advanced auto-filter? [more inside]
posted by Lucubrator on May 17, 2011 - 0 answers

How can I more easily edit CSV tables in Access or Excel?

I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
posted by filthy light thief on May 16, 2011 - 7 answers

Show all formulas.

I'm an artist. Please help me find a day job that makes use of my bizarre love of spreadsheets. [more inside]
posted by HeroZero on May 15, 2011 - 8 answers

Need help with (presumably) conditional formatting issue in excel

How do I use two cells to conditionally target a different cell? [more inside]
posted by FireStyle on May 11, 2011 - 3 answers

Using Table data to automatically (re)name worksheets in Excel 2007?

In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook? [more inside]
posted by Lentrohamsanin on May 10, 2011 - 2 answers

Excel Wizardry Needed

Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside. [more inside]
posted by unannihilated on May 9, 2011 - 5 answers

Copying contents of cells in Excel

How do I create a macro in Excel that copies the contents of the cell two cells to the target's right and appends the contents to the end of the target cell? Both cells contain alphanumeric strings. [more inside]
posted by geoffr on May 3, 2011 - 7 answers

Page: 1 2 3 4 5 6 7 8 ... 17