##
952 posts tagged with excel.

Displaying 751 through 800 of 952. Subscribe:

## Help me chose books for Access and Excel!

I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable. [more inside]

## What do I need to learn to get my trading software talking to Excel?

An Excel RTD problem [more inside]

## Fun New Product at Work

The management at the company I'm working for has sold a couple customers on a product that we as the worker-bees have yet to produce. That being said I view this more as an opportunity to do something new than as a huge hassle, assuming we can figure out a convenient way of producing said product. So I was hoping the great and wonderful MeFi might have a couple suggestions they might throw my way. [more inside]

## Help me sort my rows please!

Is there a way to sort by "highlighted field" in Excel? [more inside]

## Excel 2007 issue.

What's wrong with my copy of Excel 2007? [more inside]

## Frustration high due to Excel problem - how do I make my sorted data update in my graph?

Frustration high due to Excel problem - how do I make my sorted data update in the graph? [more inside]

## Work your Excel Wizardry

Calling Excel wizards: Splitting groceries in Excel between 3 people [more inside]

## Age formulas in MS Excel

I need to put some test score data into Excel that works with children's ages in years and months.
[more inside]

## What is a good user / "client-side" alternative to using the Internet Explorer right-click "export to Excel" feature?

What is a good user / "client-side" alternative to using the Internet Explorer right-click "export to Excel" feature? [more inside]

## Excel String-Counting Help!

ExcelFilter: Help me count rows where one string appears in one column and a second string appears in a second! [more inside]

## How to use counting formulas in Excel?

I need help with counting formulas in Excel! [more inside]

## How to compare multi-row averages in JMP?

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]

## Excel dragging other files into the party...

I've done something odd to Excel. Please help! (more inside) [more inside]

## Applescript+Excel+Pivot Table

Applescript + Excel . How to suppress subtotals for a field in a pivot table? [more inside]

## Excel: how do I calculate the last X cells?

Another excel question...working with the last X cells in a row [more inside]

## Saving Excel as A Web Page looks sooooo Ugly! Help!

I need to get a nice looking excel sheet published to the web daily. The problem: if I "save as web page" from excel it doesn't look so nice anymore as excel doesn't translate its formatting well at all, but if I were to take a screen shot and publish it as an image I lose the embedded links. What to do? [more inside]

## Help me make the graph my boss imagined!

Graphing question: My boss has an idea of how our data should be presented. Please help me figure out how to make it happen! [more inside]

## Excel N00b

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]

## excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]

## Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]

## ExcelFilter: How do I display the sum within that column without resulting in a "circular reference" error?

ExcelFilter: How do I display the sum within that column without resulting in a "circular reference" error? [more inside]

## Making two rows into one in Excel

AnotherExcelQuestion: Data that is in two rows needs to be in 1 row. I know it can be done manually, but I have data for 998 individuals to deal with. [more inside]

## Make Excel Make Coleslaw!

Excelfilter!!
Okay, how would I do this in MS Excel???
[more inside]

## 2 + 46% = ?

I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages.
Yes, I did Google this before asking. :D [more inside]

## calculate average speed with a start and end time

Excel Filter: How do I calculate average speed with a start and end time? [more inside]

## Can Excel copy text from cell in one worksheet to cell in another?

MS Excel help, please. I'm creating a multi-sheet workbook, and cells on one sheet will contain the same text as cells on another sheet. Is there a way I can avoid having to enter the text on each sheet? Is there a function that will automatically copy text from a cell on one sheet to a cell on another sheet?

## Excel translated w/o my permission.

Excel - automatically converted my numerical values - [more inside]

## Help me autoimport!

Automate Excel Filter.....
I am getting via email a CSV file daily that I would like to automate into excel.
[more inside]

## Basic MS Excel question.

Basic MS Excel questions. How do I ask for the numeric value of the Nth cell to the right of the cell with this (requested) function in it? Relatedly, is there a way to write a function in some cell that places a numeric value in a cell N cells to the right of that cell?

## Spreadsheet to calculate EI/CPP?

Are there Excel spreadsheets available for Canadian (Ontario) payroll calculation that automatically calculate EI, CPP, etc?

## How do you create text files from a spreadsheet?

How do you create text files from a spreadsheet? [more inside]

## Help me prioritize the people I bug for money

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]

## Plaintext and Excel

MS Excel: I need to place quotation marks around the numbers in a column. Is there a better way to do this than I am currently trying or is there a plaintext spreadsheet editor that would be a better solution? [more inside]

## Exce Crash

I lost all my (unsaved) work in Excel 2003 when my system did an auto-update restart without my permission.
Please Help. [more inside]

## Sorting data in Open Office

Open Office Calc and sorting data question. [more inside]

## searching for a file

Is there a way to find an excel file on your hard drive that contains a certain sequnce of digits in adjacent cells? [more inside]

## Excel macro/ pivot table help

Need help coming up with a basic training/ presentation in Excel macros and pivot tables for my boss and his second in command!
Can someone recommend a book- well written, concise?
I use Excel a lot, had advanced training (paid for by my boss) , but I don't use macros or pivot table functions because there has been no need in my line of duty...... [more inside]

## How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]

## How to iterate through controls in VBA/Excel?

How do I loop through a bunch of controls using VBA in Excel 2003? [more inside]

## Missing commas in CSV file

Why is my CSV export missing commas, which is foiling my upload? [more inside]

## Manipulation of Data

Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]

## How do I remove duplicates and then merge two excel files?

In MS Excel, how do I remove duplicates, clean up a document and merge two files together? [more inside]

## How to easily search/replace in MySQL database?

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]

## Microsoft Formula Help

How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells? [more inside]

## Excel mindless list jumping

Stop Excel from jumping to end of column when double clicking on cell border [more inside]

## Save me two weeks of manual labor, please

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?

## Excel formula question

Excel question: How to define a range so that it always adds up to a constant value. [more inside]

## Spreadsheet Cleanout

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]

## I miss my speadsheets!

Why is Excel not opening? [more inside]

## How do I create PDF forms from Access/Excel data?

I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]