##
934 posts tagged with Excel.

Displaying 1 through 50 of 934. Subscribe:

## Excel Question

Is it possible in excel to create a formula that says "if a value in this column is in this range of numbers, put label x in a different column." [more inside]

## How can I model the response of a car to a sharp steering input?

I'm doing some work for an engineering company that certifies modifications to cars.
One of the tests that they perform is a lane change manoeuvre test. This test simulates an emergency lane change and back to the original lane to prove the stability of the vehicle.
Given testing is relatively expensive (as it involves hiring a suitable facility), and involves some risk to the test driver, they have asked me to come up with a spreadsheet or similar that they can use to have a high level of confidence that the test will be safe before they leave the workshop. i don't know how to do that. [more inside]

## MS Office Reporting Service

Before writing this from scratch I'd like to know if something already exists. The need is for a server that accepts data, document type and an optional template id, and returns an MS Office doc (powerpoint or excel) containing the data, in the selected template. [more inside]

## Excel Wizards, Help Me Make My Dream Calendar

Hi! I an Excel novice surrounded by fellow novices and I need help with what looks like an unexpectedly difficult setup.
I make a comprehensive calendar of activities and events for a retirement home every month. This takes most of a month to plan and transcribe, and is tedious and error-prone. I want to make something better. Assume I am smart but have little programming knowledge or power user experience. [more inside]

## How should we manage all of these RSVPs for events at our non-profit?

Hello Mefites! I'm seeking some help finding a better method for a very inefficient RSVP process here at the nonprofit where I work. Please help me come up with a better solution! [more inside]

## How might I randomise some spreadsheet rows once I populate it?

I'm developing a training resource for a client and the brief requires me to provide some spreadsheets that summarise employment data for a small fictitious company.
The spreadsheets must have one row per employee. I want to populate the rows as if the spreadsheet has already been sorted, for example by grouping employees by age, and then randomise the rows so students are given spreadsheets where there is no row by row pattern to the data, for example as if employees had been entered in alphabetical order. [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]

## Excel Question, make chart where each bar is the average of each column

This seems simple to me but can not find the answer on-line. If I have several columns of data, each column is just one variable with several entries. How can I make a chart from this data where each chart column is the average value of each data column. Then add Std. Dev bars to this?

## Excel arithmetic glitch explanation

This isn't getting in the way of anything practical, but it's niggling that I don't understand the technicalities. [more inside]

## Help me develop complicated spreadsheet

Note: NOT Homework. Real world application here.
I have to come up with a spreadsheet based on a formula that allocates dollars to people based upon role and participation. I'm good at Excel but this one is boggling my mind. Details and example inside [more inside]

## Excel to HTML Converter

I have a work order built in excel that I want my database to auto-populate some fields instead of my QEs doing it manually. I've found an add on to do this, but if I want to make the new form look at all like the old form I have to do it in HTML. Is there a good converter for this? [more inside]

## Help me streamline a data gathering workflow?

What started as a screen scraping project has evolved (devolved?) into working with lots of word files with embedded tables. I found and customized an excel macro to extract them on a file by file basis. I'll describe what I'm doing with it inside. Can you give me some pointers on further automating what I'm doing -- or point me to a forum that can? [more inside]

## Good Excel/CSV data visualisation tools for Windows desktops?

How can I make Excel datasets look nice without too much mucking about? [more inside]

## I like to solve problems. How do I get paid to do that?

I've flip flopped on what I want to go to school for and/or what kind of career track I want to aim for. Can you help? [more inside]

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

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

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

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

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

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

## Non-cloud Google docs

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

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

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

## Serial dates are the @#$%@ devil

I need Excel to stop reverting my written date into a serial date. It is not cooperating. [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]

## Mileage in Excel (or in something else)

There has to be a way that I can track my mileage in Excel. [more inside]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

## Identify certain repeats in table

Please help me eliminate duplicates in a table based on specific criteria. [more inside]

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

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

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

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

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

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