## Math For Spacing Out Three-Day Weekends, But Accounting for Holidays

I'm a big honkin' geek, and I would like to figure out an Excel formula I could reuse from year to year to space out my vacation day choices -- but including holidays, which would prevent even distribution. How can I still get as close as possible? More inside.
posted by WCityMike on Jan 13, 2017 - 10 answers

## Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need?
posted by bologna on wry on Sep 14, 2016 - 3 answers

## FilemakerPro to .CSV to NeonCRM - How to Excel?

Excel experts and fundraising professionals, ho! I work for a small non-profit and we're currently transitioning from a janky FilemakerPro database to NeonCRM. I have all the data spread across three spreadsheets and my brain is collapsing trying to figure out the best way to deal with it. What's the best/most efficient way to compare data between three separate spreadsheets, and manipulate it into the format I need for this import? All the necessary/boring details lie within!

## How to sorting column with 10,000 rows?

I have a spreadsheet column with 10,000 rows, and I need to sort it. Is there a way to do this automatically, where certain rows with specific attributes are sent to a new column?

## Excel reverse conditional formatting

I'd like something like conditional formatting, but that works the other way - a cell's value changes depending upon the colour the cell is filled with.
posted by quinndexter on Jul 19, 2016 - 2 answers

## Excel Formula to Weight Ratings By Number of Ratings?

How do I write an Excel formula to weight a rating by the number of ratings, so that a 4 with tens of thousands of ratings weighs more than a 5 with three ratings?
posted by WCityMike on Jul 5, 2016 - 13 answers

## How do I make a VBA macro run "silently" in the background?

I have a macro in an excel sheet that successfully displays or hides tabs in the workbook based on the value in a particular cell. I'm pleased with this! There's a problem, though...
posted by jefficator on Jun 9, 2016 - 1 answer

## Why is Numbers (the spreadsheet app) for ios doing this?

I use a Numbers spreadsheet on my iPhone 5S to keep track of my mileage for work. Sometimes -- but not always -- when I do a calculation, it gives me an almost-accurate but borked up number.
posted by kitty teeth on Jun 1, 2016 - 7 answers

## Fastest/Best Way to Get Up to Speed with Excel

TL;DR: Computer comfortable/literate, but only an excel lightweight. How do I become a guru (or at least enough to fake it till I make) and start changing my life?
posted by VillainProtagonist on Mar 24, 2016 - 10 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.
posted by Lescha on Jan 18, 2016 - 6 answers

posted by triggerfinger on Jan 12, 2016 - 11 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

What's a good non-cloud collaborative software alternative to Google docs?
posted by Ndwright on Nov 19, 2015 - 7 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?
posted by ragtimepiano on Oct 10, 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.
posted by motioncityshakespeare on Aug 8, 2015 - 8 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?
posted by chudmonkey on Jun 10, 2015 - 5 answers

## Doing a Line Dance

posted by papayaninja on May 8, 2015 - 4 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.
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.
posted by Len on Mar 5, 2015 - 13 answers

## How to Tell Excel to Evaluate Last Three Months (NOT Last 90 Entries)

I have an Excel spreadsheet I use to track glucose readings. There’s a value diabetics use called “A1C” which looks at the last three months of readings. It's based on a blood test, but can be estimated by averaging your readings for the last three months. I try to track every day, but I can’t reliably say “look at the last 90 values” – so I’m wondering how to set up a formula to tell it to only look at readings going back 90 days, not necessarily 90 readings. More inside.
posted by WCityMike on Jan 19, 2015 - 12 answers

## Excel Question: VLOOKUP and beyond?

How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function?
posted by ThePinkSuperhero on Jan 15, 2015 - 9 answers

## How do I solve for a percentage of a total budget...

This will be easy for someone, but math is my second language so I'm at a loss. How do I solve for the percentage of a TOTAL budget, when one line item is unknown (and is part of the total budget)?
posted by coollibrarian on Dec 9, 2014 - 5 answers

## Excel formula: Letter to Number (and vice versa)

I'm working on a formula (not a macro) to convert a Letter (in this case, a column letter) to a Number, and vice versa. So: A = 1, B = 2, C = 3, Z = 26, AA = 27, AB = 28, AC = 29, ZZ = 702, AAA = 703, AAB = 704, AAC = 705, BAA = 1379, etc... Of my three part formula(s), I have the one-letter and two-letter columns working, but I run into issues with the three-letter columns (AAA and beyond).
posted by JimBJ9 on Dec 3, 2014 - 12 answers

## Another "data management & research database for dummies" question

I'm undertaking a research project in which I'm evaluating several different organizations based on specific yet qualitative criteria, e.g. "promotes outreach", "reports on progress", etc. I need to able to capture the information and then display the results in some sort of meaningful way so that it can be incorporated into a report.

## Counting rows in Excel that match condition?

Can an Excel expert help me with counting rows in a spreadsheet that can match one of 15 possible combinations?
posted by dukes909 on Nov 24, 2014 - 15 answers

## 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.
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.
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...
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.
posted by trogdole on Aug 7, 2014 - 10 answers

## How to create an Excel histogram showing distribution of timestamps

I have a spreadsheet containing timestamps, that I want to display as a histogram
posted by jedro on Jul 17, 2014 - 1 answer

## 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.
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.
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.
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?
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?
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.
posted by ellieBOA on Mar 6, 2014 - 10 answers

Help me turn my iPad into a work productivity tool.
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.
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.
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?
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.
posted by sockpuppetfairy on Jul 18, 2013 - 3 answers

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.
posted by oblique red on May 30, 2013 - 4 answers

## There's got to be a way...

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.
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.
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.
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.
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?
posted by pwb503 on Jan 22, 2013 - 8 answers

Page: 1 2 3 4 5