199 posts tagged with resolved and Excel.
Displaying 1 through 50 of 199. Subscribe:

Tracking reimbursements for employees

I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
posted by thefang on Sep 25, 2014 - 3 answers

Pivot table help for n00b

I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]
posted by Bretley on Sep 21, 2014 - 8 answers

is this a good use case for a gamma distribution?

I want to generate synthetic user-session data to predict how big a peak in application usage might be shortly before a weekly deadline (for timesheet submission - it's a time and labour tracking application). I've come up with a method that looks like it works - it involves a gamma distribution for the login time. But I don't have enough (in fact, any) statistical training to know whether I'm using that distribution meaningfully. Statisticians, please reassure me. Thanks! Excel functions inside... [more inside]
posted by rd45 on Sep 10, 2014 - 3 answers

Excel Filter: IF Statements and Concatenate

I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]
posted by trogdole on Aug 7, 2014 - 10 answers

Labeling data points in an Excel chart

Help me figure out how to get the labels I need on the data points in a fairly simple Y vs. X chart. [more inside]
posted by ocherdraco on Jul 8, 2014 - 15 answers

How to get Excel to play nice?

I am trying to generate an excel graph that will give me a date/time overview, and I can't quite crack how to set up my table and chart :( Any help will be greatly appreciated. [more inside]
posted by alchemist on Jul 4, 2014 - 6 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 21 answers

excel numbering questin

In excel, I want to increase a number in sequential rows by one every three numbers. Is there a way to do this quickly, for about 5000 rows? [more inside]
posted by SpacemanStix on May 22, 2014 - 7 answers

Make me an Excel rockstar!

What are some of the most useful Excel add-ins that you use on a daily basis? [more inside]
posted by rippersid on Apr 11, 2014 - 9 answers

Excel formula that hides results

I am drowning in Google results! Looking for help making a formula that will only show a value once data is entered into another cell. [more inside]
posted by ellieBOA on Mar 6, 2014 - 10 answers

iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]
posted by sardonyx on Feb 17, 2014 - 10 answers

ISO: 21st Century - information wants out of 3 ring binders

We have a number of (internal) groups providing information about (external) clients. Help me figure out the best way to track this information for easy report generation. [more inside]
posted by TravellingCari on Jan 10, 2014 - 5 answers

Convert rich text field in Access or Excel into plain text

I have thousands of rich text message message fields currently formatted in RTF (rich text format) that need to be stripped of their formatting and converted to plain text. Currently the field is in a Microsoft Access database. But if needed, the database could be sent to Excel if that would ease the conversion of the RTF to plain text. [more inside]
posted by Jackie_Treehorn on Nov 12, 2013 - 16 answers

Excel imported my dates as day-month instead of year-month. How to fix?

How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
posted by rebent on Aug 26, 2013 - 6 answers

Rearranging the formula for Compound Annual Growth Rate

How do you rejig the formula for CAGR to get the starting value when you know the other variables? [more inside]
posted by MuffinMan on Aug 1, 2013 - 3 answers

Professional education/seminars?

My employer has allocated $500/year as a benefit to me for training. I have not used it yet this year - suggestions? Areas I'd like to focus on - accounting, excel, QuickBooks, management training. I'm open to other things if they would be useful. [more inside]
posted by sockpuppetfairy on Jul 18, 2013 - 3 answers

Download Excel on a PC running Vista

Need to get MS Excel on a PC running Windows Vista. Latest Excel versions seem to require Windows 7 or 8. Any help on where I can get a downloadable version of Excel for Vista?
posted by BozoBurgerBonanza on Jun 19, 2013 - 6 answers

Rounding dates based on time in Excel

I am looking for a way to take a date and time entry in Excel 2010 and round it up to the next day if the time is after a certain value. [more inside]
posted by oblique red on May 30, 2013 - 4 answers

There's got to be a way...

Excel functions: OFFSET? LOOKUP? ADDRESS? Unconfuse me, please. [more inside]
posted by jon1270 on Apr 23, 2013 - 7 answers

MS Word / Excel 2011 for Mac catalog merge mystery

I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records. On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document. [more inside]
posted by mwhybark on Apr 15, 2013 - 1 answer

simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]
posted by clockzero on Mar 26, 2013 - 8 answers

No, this isn't about EVE Online.

I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
posted by 256 on Feb 28, 2013 - 10 answers

Using Excel conditional formatting to do a name/ID data check?

I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside. [more inside]
posted by bibbit on Feb 25, 2013 - 4 answers

How do I figure out how to divvy out these projects?

I have roughly 20 people who each need a project. I have 27 projects and don't want anyone to share a project. I let the people pick their top five projects and rank them so I know who wants what. What is the best (easiest...) way for me to fairly figure out who should get what project so that the most people get their top choice, or at least one of their top choices? [more inside]
posted by pwb503 on Jan 22, 2013 - 8 answers

Correlating names between two spreadsheets

I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names. [more inside]
posted by mammary16 on Jan 18, 2013 - 8 answers

How can I get access to readyState 3 with VBA "AJAX"?

I'm writing some VBA code (in Excel) which uses a reference to Microsoft XML, v6.0, and creates a MSXML2.XMLHTTP object. I used the clsXMLHttpMonitor example from this page as a starting-off point. How can I access the response text when readyState = 3? [more inside]
posted by jozxyqk on Jan 8, 2013 - 10 answers

How to jump to another Excel worksheet?

[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
posted by aqsakal on Dec 12, 2012 - 7 answers

Giant CSV Files Needed

Where can I find publicly-available scientific data to use in an Excel project? [more inside]
posted by anaximander on Oct 30, 2012 - 18 answers

Excel Help

Excelfilter: How do I find and replace (e.g. replace 17 for 18) a set of numbers in the format: 17-01-06 without it being recognised as a date? [more inside]
posted by freddymetz on Oct 30, 2012 - 4 answers

In Excel, getting the MEDIAN of a set based on a text pattern match

In Excel, I have two columns. Column A has many rows of names (e.g., Mary, Maryjane, Maryanne, Anne, Jane) and in Column B I have their ages (e.g., 4, 20, 40, 10). I would like to find the MEDIAN age of all the "mary's"; i.e., both "mary" and "maryanne", etc. Is this possible? I have been getting errors on variations of {=MEDIAN(IF(A1:A4="*mary*",B1:B4))} constructions... I do not want to use VBA. thank you!
posted by noway on Oct 26, 2012 - 5 answers

How to Highlight All Cells Containing Future Date in Excel 2007

In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future? [more inside]
posted by smirkyfodder on Oct 15, 2012 - 2 answers

Ideal ranges in excel charts?

Displaying ideal ranges in the plot area of an Excel 2007 chart. Possible? [more inside]
posted by xyzzy on Oct 11, 2012 - 2 answers

What are the dates for the 9th and 20th business day for the rest of this year and all of next year?

I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum on Sep 14, 2012 - 6 answers

Seeking on-line training in MS Office

Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg on Sep 4, 2012 - 8 answers

Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]
posted by hrj on Aug 9, 2012 - 24 answers

How to populate PDF form from Excel data?

How to populate PDF form from Excel data: number of copies based on number of rows? [more inside]
posted by GuppieXX on Jul 13, 2012 - 3 answers

Info from Silverlight into Excel?

Can I get this information from a site on Microsoft Silverlight into Excel? [more inside]
posted by quadrilaterals on Jul 5, 2012 - 5 answers

What are the best ways to increase Excel skills?

What are the best free and paid resources or training courses for Excel? [more inside]
posted by ramenopres on Jul 1, 2012 - 7 answers

Help me pivot the pivot table back!

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed. [more inside]
posted by Frowner on Jun 20, 2012 - 6 answers

html tables are killin' me.

How do I import tables from HTML into Excel when some cells have multiple lines? [more inside]
posted by KGMoney on Jun 14, 2012 - 6 answers

Excel copy/paste question

Probably a simple Excel copy/paste issue... [more inside]
posted by xedrik on Jun 8, 2012 - 5 answers

Conditional formatting, with limitations.

How do I set conditional formatting in Excel based on whether a list value has been selected in a range of other cells? [more inside]
posted by doyouknowwhoIam? on Jun 2, 2012 - 1 answer

Is creating a compound line graph possible with this dataset?

Is creating a compound line graph possible with this dataset? If yes, how? If not, how should I set up the data? [more inside]
posted by chillmost on May 31, 2012 - 3 answers

Condition Excel... And Repeat

Excel Filter: Advanced Conditional Formating, Format based on type of formula used (average, sum, sumproduct etc..) [more inside]
posted by MechEng on May 7, 2012 - 5 answers

How to determine relationship between two dimensions of a 3 x 3 frequency matrix?

Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]
posted by Susurration on Apr 10, 2012 - 10 answers

Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 answers

EXCEL QUESTION LOL

I have a data set of user activity. It records every time an activity is completed by a user, with the date and user ID attatched. I need to tally up the number of times, by user, the user completes the activity on a unique day. [more inside]
posted by Patbon on Mar 5, 2012 - 13 answers

Can a sortable spreadsheet exist in a PDF?

I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]
posted by Servo5678 on Feb 17, 2012 - 5 answers

Comparing Excel Sheets for Sanity and Such Things

ExcelFilter: Compare rows for data changes? I want to find out whether row values are different between two sheets on records that match. [more inside]
posted by kensch on Feb 1, 2012 - 6 answers

Excel SUMIF function - what condition am I looking for?

ExcelFilter: how do I get SUMIF to work so that if a cell in the reference range is blank, the corresponding cell in the sum range is picked up in the sum? [more inside]
posted by sillymama on Jan 31, 2012 - 5 answers

Page: 1 2 3 4