920 posts tagged with excel.
Displaying 1 through 50 of 920. Subscribe:

Writing MS Word macro to convert glossary formatting to Excel table

I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column. [more inside]
posted by beammeup4 on Jan 25, 2016 - 5 answers

Excel filter: How do I add only data for a given month?

I have an Excel worksheet that logs hikes. The columns are date, location, miles, notes. The rows are hikes. I have a summary worksheet in the same workbook that I use to track progression. Things like cumulative miles for the year, average miles per month. I'd like to add month by month totals. I want to write a formula that will sum the distance only for a particular month (for example, January). I need a formula that will test if the hike occurred in that month, then add the miles to the sum. What would this formula look like? [more inside]
posted by OrangeDisk on Jan 21, 2016 - 5 answers

Volunteered to add up the votes for my Book Club; No idea how to do it

This year my Book Club decided to vote on the books we'll read all at once instead of month-by-month. There are 17 books choose from in total and I gave each person a sheet with the books in alpha order. I then asked them to order the books by preference – i.e., their first choice is #1, their second #2 etc. [more inside]
posted by Lescha on Jan 18, 2016 - 6 answers

Need help wrangling spreadsheets

Spreadsheets are making me crazy. [more inside]
posted by triggerfinger on Jan 12, 2016 - 11 answers

New Year, new spreadsheet for tracking joint and personal expenses

My partner and I have decided to track more accurately our expenses and this task is on me. We are looking for an Excel spreadsheet template that will allow us to track all our expenses by category (groceries, eating out, etc), making a distinction between personal and joint expenses. On top of that, we would like to be able to see clearly who spent how much on what. [more inside]
posted by lost_lettuce on Jan 12, 2016 - 12 answers

UK business plan financials excel sheet?

I am looking for a straightforward British economic business plan financials calculator for Excel so that I can look serious! I found a similar thing from startupmodels.com but it is really for the USA. Any signposting to something comprehensive with built in calculations?
posted by parmanparman on Dec 20, 2015 - 3 answers

Excel 2013 - I have no explanation for this chart behavior. Do you?

Excel 2013 - I have no explanation for this chart behavior. Do you? [more inside]
posted by radiosilents on Dec 15, 2015 - 6 answers

Non-cloud Google docs

What's a good non-cloud collaborative software alternative to Google docs? [more inside]
posted by Ndwright on Nov 19, 2015 - 7 answers

Excel autopopulating columns from a list

What is the formula to have Excel pull information from a list based on a specific identifier? [more inside]
posted by OnTheLastCastle on Nov 11, 2015 - 7 answers

Need some Excel-Fu!

I have an excel doc with products down the left and people's names across the top. The people have each marked in their column the quantity of each product they would like. How do I make sure everyone gets what they want? [more inside]
posted by magnetsphere on Nov 5, 2015 - 7 answers

Serial dates are the @#$%@ devil

I need Excel to stop reverting my written date into a serial date. It is not cooperating. [more inside]
posted by Serene Empress Dork on Oct 16, 2015 - 8 answers

How do I make a directory from excel or .csv files?

I need to make a directory of members from a .csv file---what is the easiest method? [more inside]
posted by ragtimepiano on Oct 10, 2015 - 4 answers

Mileage in Excel (or in something else)

There has to be a way that I can track my mileage in Excel. [more inside]
posted by aetg on Oct 6, 2015 - 5 answers

Help me escape Excel hell

I need to build a database that's viewable on the web, but for internal use only, among friends. How to do this painlessly? Google spreadsheet is not exactly making it any easier. [more inside]
posted by pleasebekind on Sep 10, 2015 - 9 answers

Recommend a second VBA book?

I'm looking for a book recommendation for someone who's already pretty familiar with vba and wants to go beyond the basics. [more inside]
posted by Proginoskes on Sep 1, 2015 - 6 answers

Spreadsheet - Naming calendar quarters with custom date

I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]
posted by primethyme on Aug 29, 2015 - 4 answers

Best resources to help improve/maintain old code

What are some resources (books preferred, but other resources are good, too) that I can use to help me improve/maintain some old vba models in my workplace. [more inside]
posted by Proginoskes on Aug 24, 2015 - 4 answers

Generating a graph from excel

I have an excel file with two columns that I'd like to somehow (in the easiest way possible) turn into a graph (in the graph theory sense - with nodes and edges). [more inside]
posted by Proginoskes on Aug 14, 2015 - 4 answers

Fix my department's Excel nightmare!

I work in a Quality Assurance department for a call center. We have over 50 people and between us we evaluate customer interactions from 10 different departments. Right now we are using Excel to create work assignments. Example: Department 1 has 30 Excel lists each with 1/30 of the associates. This is a nightmare. Help me make it less of a nightmare. [more inside]
posted by motioncityshakespeare on Aug 8, 2015 - 8 answers

Sorting data in Excel: style information and extra cells left behind.

When I attempt to sort my Excel spreadsheets, some style information is left behind. It also doesn't sort empty cells. I want to fix this. [more inside]
posted by Kutsuwamushi on Aug 6, 2015 - 7 answers

Tracking small bits of information without Excel

I'd love to find a solution for quickly building lists, tracking information and exporting the info into an attractive report without using Excel. The program needs to be installed on my computer (not an online solution like Google docs). Does anything like this exist? [more inside]
posted by biscuits on Aug 2, 2015 - 13 answers

Excelfilter: Get max from selection of items based on another column?

I have an Excel question. I have a list of items, some of which are duplicates. Each item has a figure attached. I'd like to find the maximum value for each duplicate item and put that in another cell. [more inside]
posted by synecdoche on Jul 26, 2015 - 5 answers

Help with ambiguous Excel for Mac error message?

My other half uses Excel for Mac (14.4.3) to help with work scheduling. When he went to open his treasured scheduling file today for the first time in a few months he got the message "Excel saved changes to the file before the application quit unexpectedly. Do you want to open the last saved version of the file?" What do the choices "cancel" and "open?" mean in this circumstance? [more inside]
posted by charmedimsure on Jul 9, 2015 - 4 answers

How do I delete custom lists in excel?

How do I delete multiple (several thousand) custom lists in excel all at once? I can delete them individually, but if I did that I would end up wasting a ton of time. [more inside]
posted by lucy.jakobs on Jun 23, 2015 - 2 answers

EXCEL: filling a cell with a complete date based on just the day?

Excel question: Can I enter just a 1-31 value into one cell and have a complete date appear in a different cell based on fixed month and year values? [more inside]
posted by chudmonkey on Jun 10, 2015 - 5 answers

creative IT solution for computer illiterate federal employee

Is there a way to solicit responses to weekly queries in a way that would allow a tabulation of the responses without allowing anyone else to see another individual's answers? Difficulty level -- working for the federal government so have to do this within sharepoint and/or using excel spreadsheet. [more inside]
posted by notcomputersavvy06 on Jun 10, 2015 - 2 answers

How do I supercharge Excel's Data Validation tool?

(Background at the top; question at the bottom) I work for a tech company and clients routinely send us their data for us to process. These are quasi-employee records, including the employee's department, location, age, etc. They give us all of the valid selections for each of these fields as part of their initial account setup and we can change them at any time. These are the selections they've chosen and most often match what is in their HRIS. But, they often send us mismatching data... [more inside]
posted by Twicketface on Jun 3, 2015 - 3 answers

IF/THEN Excel Question: IF A1=any text THEN D1=1, if blank nothing

I am trying to create a list that then calculates the quantity of people on the list. I want a formula that will check A1 and B1 and see if they are blank, if so, I want nothing, if they have anything in them, I want them to be added together. I don't know exactly how to do this formula. [more inside]
posted by MnMrMstrd7 on Jun 2, 2015 - 7 answers

Google Apps Script to detect changes to spreadsheet, add timestamp?

I want to use Google Apps Script to detect when certain cells in my Google Sheet are changed, and write a timestamp in another cell to denote when they were changed. I can't use the NOW() function because it gets re-evaluated every time the sheet is calculated. I need a more permanent timestamp. [more inside]
posted by reeddavid on Jun 1, 2015 - 1 answer

Identify certain repeats in table

Please help me eliminate duplicates in a table based on specific criteria. [more inside]
posted by adamrice on May 8, 2015 - 4 answers

My Math/Excel Ignorance is Showing

In three cells in a single column in Microsoft Excel, I'd like to be able to input a number in the bottom cell, have the middle cell calculate what a 6% sales tax on the figure below it is, and provide the amount before that 6% tax in the top cell. Any help will be appreciated. The last math class I took was 44 years ago and I didn't pay much attention in that one.
posted by imjustsaying on May 8, 2015 - 8 answers

Doing a Line Dance

There are these selectable objects/lines all over my Excel spreadsheet. Instead of selecting a cell, I'll often accidentally click one of these instead, and it is very annoying. Please help. [more inside]
posted by papayaninja on May 8, 2015 - 4 answers

Where can I find a library of Macros for Excel and what they do?

I've been recently getting interested in various Macros and what they can do in Excel. Is there suppository of various Macros available online as well as clear demonstrations of what they can be used for that I can insert into my spreadsheets.
posted by RapcityinBlue on May 7, 2015 - 3 answers

Making a series of graphs from a dataset

I need to make a series of 40 graphs (all of the same format) from an excel dataset and I'm having trouble figuring out how to do this efficiently. Basically, I would want something that would cycle through all the rows producing a separate graph for each row that could be copied into the appropriate section in the report. Although, I would prefer to do this in excel so that others in my dept could also use it, I do have R available if there is an easier way to do this in that environment. Any ideas? Thanks!
posted by buttercup on May 5, 2015 - 6 answers

Directory Mail Merge to Email Messages?

I have a spreadsheet that has students’ names and their class schedules. We want to be able to email the class schedule to the students using an email mail merge. I am willing to use Excel/Word or Google Docs/Sheets. I think I have figured out how to use a directory mail merge in Word to print the schedules, but we really need to email the schedules to the students instead of print them. [more inside]
posted by allison00 on Apr 30, 2015 - 10 answers

Excel is being mean to me.

I need to have two Microsoft Excel documents open side by side, on my monitor, at the same time. However each time I open a second document, the first one disappears and turns into the second, so only one of the two documents shows on my screen. [more inside]
posted by elf27 on Apr 10, 2015 - 7 answers

Where can I find Excel exercises that will help me ace my job interview?

I will be having a job interview that requires me to have some knowledge of Excel. I know this is vague but it includes, I presume, filters, hlookup, vlookup, and establishing filters to search out education data. The interview is to get a data analyst fellowship in the education setting. [more inside]
posted by RapcityinBlue on Apr 7, 2015 - 6 answers

Good online free or cheap courses in project management and Excel?

I recently started a new job as a Project Manager for an educational travel company and would like to beef up my Excel and project management skills. I was previously managing academic research studies. While a lot of that experience is relevant, my new responsibilities are more in line with those of a formally trained/certified Project Manager and so I’d like to do some self-study outside of work. Any recommendations out there for good online coursework? [more inside]
posted by AlmondEyes on Mar 29, 2015 - 3 answers

I need a simple excel macro and I'm willing to pay.

I often (upwards of 15 times a day) need to select some of the text within a cell or textbox in Excel, and format it bold and red. Not all the text in the cell/box -- just the text I select. Is it possible to write macros to do this task? And where should I go to find someone to write it? [more inside]
posted by NoiselessPenguin on Mar 24, 2015 - 13 answers

Creating a data entry form in Excel

Hey Hivemind, So I am just beginning to foray into excel. I have create a worksheet for data entry and it has a lot of columns. To make my life easier, I viewed this website which provide a tip to make data entry more manageable. The author suggested to create a data entry form, http://www.launchexcel.com/excel-data-entry-power-tips. However, I cannot get this to really work in excel, it only partially works, excel is saying that the table is too large. Any ideas on how I can do this? Is there a work around?
posted by TRUELOTUS on Mar 19, 2015 - 5 answers

help me excel in spite of excel

ran a test that spits out a text file, need to excel it. having issues. more inside. [more inside]
posted by koroshiya on Mar 18, 2015 - 13 answers

Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result. [more inside]
posted by Len on Mar 5, 2015 - 13 answers

How to use excel, particularly for qualitative data coding

I have limited experience with Excel. However, some of the templates, when you open a new workbook are beautiful, I have no idea how to make those types of workbooks. Any advice on online tutorials that take you a little beyond the basics? Also, I am making a template/workbook to capture qualitative data. I am not using a qualitative data analysis software, just Excel, any tips or tricks on this? thanks
posted by sistertips on Mar 4, 2015 - 3 answers

Help me with a noob Excel Power View thing?

I've recently discovered Excel's Power View plugin and I'm naive enough to think it can solve a problem I have. I've watched this pie chart video (about halfway down). I can't make it do the 'partially shaded slices' thing in the video at 3:23. Help? [more inside]
posted by obiwanwasabi on Feb 27, 2015 - 2 answers

Cleaning up timestamp information in Metafilter Infodump

Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help? [more inside]
posted by Sreiny on Feb 26, 2015 - 5 answers

Spreadsheet Model Automated Testing

I'm looking for recommendations on software or practices to do automated testing of spreadsheet models. [more inside]
posted by Just this guy, y'know on Feb 26, 2015 - 2 answers

Excel help! Calculating averages across multiple sub-categories

I only have a basic understanding of Excel functions. I know that it's possible to do what I want, but I'm not sure how to go about doing it. I need help figuring out the average amount of time that passes between the dates two particular actions happen across multiple different people. I'm looking for the overall average, as well as the average for each person. Complication, some of the rows don't have the action I'm interested in tracking, so that column reads as N/A and is messing up my formula. [more inside]
posted by Arbac on Feb 25, 2015 - 6 answers

How to organize email from a particular sender?

With my gmail account I am in frequent contact with a particular individual. So frequent that our emails are kind of a mess, and I want to know if I can organize them in any way. [more inside]
posted by zardoz on Feb 8, 2015 - 4 answers

How to split a line chart by day of the week

ExcelFilter: I have two columns of data- column one is every day in a month, column two is attendance. I'd like to have a line graph that shows the data split into 7 lines- one for Mondays, one for Tuesdays, etc. How can I do this?
posted by BuddhaInABucket on Feb 1, 2015 - 2 answers

Master Data Me

How can I better track specific parts of my life with an app or spreadsheet? [more inside]
posted by Bunglegirl on Jan 25, 2015 - 8 answers

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