##
225 posts tagged with resolved *and* Excel.

Displaying 1 through 50 of 225. Subscribe:

## 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. [more inside]

## Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need? [more inside]

## 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! [more inside]

## 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? [more inside]

## 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. [more inside]

## 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? [more inside]

## 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... [more inside]

## 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. [more inside]

## 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? [more inside]

## 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]

## Need help wrangling spreadsheets

Spreadsheets are making me crazy. [more inside]

## 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?

## Non-cloud Google docs

What's a good non-cloud collaborative software alternative to Google docs? [more inside]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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. [more inside]

## Excel Question: VLOOKUP and beyond?

How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function? [more inside]

## 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)? [more inside]

## 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). [more inside]

## 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. [more inside]

## 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? [more inside]

## 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]## 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]

## 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]

## 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]

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

I have a spreadsheet containing timestamps, that I want to display as a histogram [more inside]

## 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]

## 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]

## 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]

## 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]

## Make me an Excel rockstar!

What are some of the most useful Excel add-ins that you use on a daily basis? [more inside]

## 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]

## iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]

## 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]

## 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]

## 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.

## 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]

## 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]

## 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?

## 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]

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

Excel functions: OFFSET? LOOKUP? ADDRESS? Unconfuse me, please. [more inside]

## 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]

## simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]

## 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]

## 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]

## 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]