Skip
##
866 posts tagged with excel.

Posts

##
866 posts tagged with excel.

Displaying 1 through 50 of 866. Subscribe:

## Turning a single column of data into a four-replicate column

My data are outputted from the source as a single-value column, but I'd like the data formatted as a four-replicate column. Is there a function in Excel for this? [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]

## How do you convert Excel checkboxes to text?

Is there an easy way to convert Excel checkboxes to text? I have hundreds of workbooks I'm trying to combine. They all have 7 columns of checkboxes and varying numbers of rows. Once we get to a few hundred rows in the individual workbooks the file starts wanting to hang, so when I combine all of these workbooks, I'm envisioning a lot of pain. Is there a quick and easy way to replace these checkboxes with simple text? Something as easy as find and replace would be ideal.

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

## Way to export patent data to XLS or CSV?

I need to get some patent data (Pat Number, Issue Date, Main Claim, Abstract, Forward and Reverse References) from about 100 patents into excel. Is there a site that does this for free? [more inside]

## Help me quantify extra hours, please, please, a please please.

I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this? [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]

## Moving around and renaming a massively linked Excel folder

At work I have the responsibility for an Excel-based model, which is a nested series of workbooks and folders with many links to each other. We need to be able to rename the master folder, move the folder about, and keep all links still linked to the enclosing folder. [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]

## How do I play Mad Libs with an Excel spreadsheet and Word doc?

I have a spreadsheet that contains information I want to use to fill out a form, Mad Libs style. Essentially, I'd take each row of the spreadsheet and use the cells to populate a text document. It's not actually in Excel/Word - it's in Libreoffice, if that changes anything. I also need room for conditional if-then statements, because some text may require additional accompanying notes.
I tried generating a pdf in Nandeck (card game generation software) but that doesn't work well for formatting text relative to other text, so I'm looking for a better solution.

## A Database So We'll Never Have to Retype Again

Give me your best invitation/list/contact/event management software suggestions. My employer hosts numerous events every year. Most are political, and seek to raise money or garner support. All require complex invitation lists, based on affiliation or past attendance at similar events. Do you know of any very

**user-friendly**list management software that will create contact lists based on this kind of criteria? [more inside]## Importing hyperlinks into Excel

As users of Excel may know, only one hyperlink is allowed per cell. I'm trying to import HTML tables in which there are sometimes two hyperlinks per cell. The Excel importer does not seem to like this, so it gets rid of the link. Is there any way around this? [more inside]

## Taking data from a PDF and putting it into a spreadsheet

I have a PDF with several hundred pages. Each page is formatted identically and contains data on a single person, divided into various tables. I want to parse the PDF so that each person's data is a single row in a spreadsheet, with various key points (e.g. "name") in the same column. I feel like this has to be an already-solved problem. How can I do this?

## How can I print custom nametags? I feel like a dummy...

I need to print simple 4"x3" conference name badge inserts - just first name, last name, and a custom background image. I have Word, Excel, Illustrator and Access (though I've never used Access).
I have the names in an Excel spreadsheet, and I've created a nice .jpg/.png image as the background. How do I pull this all together? Thanks!

## Best way to convert 900 HTML table files to CSV?

Does anyone know of a friendly program for batch-converting a folder full of hundreds of HTML tables to CSV format that will load in Google Spreadsheets? I know I could just load one in Excel but I need to automate it to handle tons of these files.

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

## Inserting symbols before and after some other text in Excel (macros?)

Is it possible to do this in Excel or Word or some other program?: I want to paste a sentence into the a text field, highlight a word or several words in that sentence, hit a keyboard shortcut, and have certain symbols inserted before and after that word or phrase. For example, in the sentence "Metafilter is the best website in the whole wide world," I might highlight "website," press the shortcut, and have it transform into the following: "Metafilter is the best {{c1::website}} in the whole wide world." I'm using OSX and Microsoft Office 2011, but I'm comfortable doing this in a webapp or Google Drive or whatever you suggest! I also have the aText text expansion software, but I can't figure out how to make it insert text at both ends of a highlighted phrase. [more inside]

## File woes

I grabbed a bunch of posts off of a vBulletin forum to analyze for a research project (with permission, of course, from the forums and the users and my IRB), and I've got it all cleaned up and ready to go. I've got thousands of files in .xls (Microsoft Excel 97-2003) format. So far, so good. Now how do I get these files into a format that my analysis software will play with nicely? [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]

## Turning a giant spreadsheet of order info into "Here's your order info!"

I have a giant excel spreadsheet with ~2200 customers worth of order details for a Kickstarter. The details are complex; I have around 60 products I'm delivering, and I'd like to send everyone an email with their individual orders before I start shipping them out. How do I do this? I'm planning on outsourcing this job, but I'd like to know a bit more about who I'm trying to hire (An excel expert? A mailing list person? Some other platform I don't know about?)

## What are some interesting facts about Microsoft Excel?

I work extensively with Microsoft Excel, and I'm putting together a list of little known facts about Excel for a presentation. I haven't found much on the interwebs that's exceptionally interesting. Does anyone have any facts they can share that come from off the beaten path? [more inside]

## Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack.
I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [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]

## Make my task list easier

I need to create a list of tasks that rotate between a number of employees on a monthly basis. I'd like the ability to assign a variable number of tasks to each employee, so one person might receive one task and another two. Previously this had been done manually on an excel sheet; can you think of any way to semi-automate it? [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]

## Linking Excel data to Word docs: Portability?

I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? [more inside]

## Looking for an advanced Excel/Access crash course

VBA and Macros and VLookup, Oh My!
I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start.
Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?

## Making Excel do stuff for me, automagically!

Where can I find snippets of vba macros that I can use/reuse? What are your favorite macros that you use and can't do without? [more inside]

## Random Numbers In Excel, Without Duplicates, Based On Weighted Value

I need a way to generate a random set of numbers in excel, with some numbers having a more likely chance to be selected based on a weighted value associated with that number. But without the number being duplicated. [more inside]

## Unusual Excel-to-Word merge. Is this possible?

Have Excel spreadsheet with a list of contacts with the name of the organization they belong to. Need a series of Word documents for each organization that includes the names and info of each contact. Read on for more detail. [more inside]

## How much to ask for informal consulting?

A coworker of mine asked me to help his friend out with some excel problems she is having. I am good with excel, so I agreed. We've talked and are all set to go, but I have no idea how much to ask for. [more inside]

## Need help with getting things to sort correctly in Excel

I have a spreadsheet with items that I am trying to organize by part numbers made up of both letters and numbers. When I sort them, though, "HMDL32000" comes ahead of "HMDL3700", even though 32000 is a bigger number. In the warehouse, HMDL32000 is behind HMDL3700 and it seems unintuitive to have it appear first on the spreadsheet. How can I get Excel to organize first by the alphabetical portion of the part number, and then in the correct numeric order?

## Please help me gain Microsoft Office skills!

I will soon be starting a project/new job that requires better Microsoft Office skills than I currently have. I've used Outlook, Word and Excel in a fairly basic way for years, but need to come to grips with some of the more sophisticated elements of those programs. Plus, I need to learn how to use Powerpoint and Visio, which I've never touched. Yikes.
Can you recommend some good online tutorials? I am also considering doing a paid course (online or otherwise) if I can find one based in London that's not too expensive or a rip-off. Can you help?

## Is it possible to open multiple instances of Excel 2010 in Windows 7?

I want to be able to open multiple instances of Excel 2010 in Windows 7 on a PC. This is the default for opening Word docs but for some reason Excel limits me to multiple windows inside one instance. Is there a way to do this?
Challenge: I do

**not**have the ability to edit the registry on this (work) computer.## How to transfer Excel data to Powerpoint easily?

I have a list of names on an Excel file. I'd like to transfer each name (along with other details) to one PowerPoint slide. Is there any way I can do this without having to manually type in each name?

## Excel question: VLOOKUP what's already been VLOOKUPed?

Is there a way to look up items in Excel that are not included in a total that has been calculated using multiple vlookups? [more inside]

## How can I add straight "limit" lines to simple Excel X/Y graphs?

I'm using Excel 2010 and I'm making several x/y scatter graphs to plot QA results. I want to show on the graphs an upper and lower allowed limit for the data. [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]

## Getting crazy duplicate charts in Excel spreadsheets using Save to Web

So, I have a series of worksheets in an Excel file that I routinely save to web (single web page format) so that colleagues can access the information on an intranet. Since our company upgraded to Office 2010 these worksheets have begun accumulating multiple copies of any charts located on these sheets (superimposed on the original) - these duplications are in both chart and image form. [more inside]

## Creating simple bar graph in Excel 2007

Hey guys, what I'm trying to do is very simple I just never really use Excel. I have two unrelated fields, categories, or columns, that I'd like to depict in a bar graph showing the amount of records that have been completed out of the total. The data are values, in my case "Yes", not numbers. I used the countif() formula to count every cell that has "yes". But I'm not really sure what I have to do next. Do I need to create another row showing what percentage this number is from the total amount of records, 136/633? And then create a bar graph from just that cell? When I just highlight all the cells for both columns and click bar graph it doesn't even fully show me a graph so I'm obviously not doing it right. Ideally, I'd like the y-axis to just show 0-100% and the total number of records(633) with marks maybe at 25% intervals. The x-axis to have my two column names and then the bars showing the percentage of records that have "yes" for these columns out of the total with a count included also.
If anyone could help me out that would be great. Thanks a ton in advance.

## How to add multiple images at a time in Excel

I unpacked a bunch of boxes, took photos of what was inside, and then packed them back up. I would like to create a simple inventory of the boxes with columns for box #, a photo of the contents, and a description of the contents. Here is sort of an idea of what I am trying to accomplish. [more inside]

## How big of a security risk is Office 2003 for my limited personal usage?

I am still using Office 2003 for personal use. It meets my limited needs perfectly well, and I want to avoid learning curves and costs associated with alternatives if at all possible.
I understand that Microsoft will no longer be issuing security patches for it soon, so there are potential risks in continuing to use it, but how serious are those risks given my actual pattern of use? And can they be easily mitigated by avoiding various features or behavior? [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]

## Excel sum question with if and operators

Spread sheet contains 4 columns.
Submitals, interviews, jobs and a total sum column of the prior three cells mentioned.
The trick is, a submital is worth 1 point, a intrerview 3 points, a job 5 points. But the value must be 1 each in its respective column, and the sum column must contain the total number of points. How would you format a sheet to achieve this.

## Conditional Excel formula to identify right-most column with a value?

I'm grappling with an Excel formula. Given a bunch of columns, I'd like to to (a) identify the right-most column that contains a value, then (b) fill a cell with that value and the value in the column heading. [more inside]