Skip
##
866 posts tagged with excel.

Posts

##
866 posts tagged with excel.

Displaying 701 through 750 of 866. Subscribe:

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

## Excel help.

Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year) [more inside]

## Merging Excel Sheets (With a Macro?)

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]

## To underscore or not to underscore?

Is there an advantage to having an underscore in a file name? [more inside]

## Counting challenge in Excel

Excel question: I can't figure out how to count what I want to count... [more inside]

## Mailmerge Filter (how to create separate docs)

I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]

## excel/word online tutorial

My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
Regards/p &k

## Finding the right Microsoft Excel formula

I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!

## Cheap copy of Excel for Mac?

Where can I get a cheap copy of Excel for my mac? [more inside]

## Error When Exporting Access Report to Excel

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]

## Excel - relative vs. absolute chart time

Excel question on charting time - how to make it appear relative, not absolute? [more inside]

## Excel Hell

How can I open a Microscoff Excel (Macintosh) version 1 document? [more inside]

## Strip HTML from Excel

I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]

## Excel cells as input AND output?

Excel wizards: is it possible to create a temperature conversion calculator (Celsius, Fahrenheit, and Kelvin)

*using only 3 cells for the interface*? I have the conversions and know how to do conditional formulas, but what tricks would be involved in having each cell handle both output and potential input?## Excel: Connecting the dots between inconsistent data

Excel: I am trying to create a line graph of last year's workload versus this year's workload. Problem is, I don't have consistent data and my graphs have numerous gaps between data points. How can I best fill these gaps? [more inside]

## My Mac(Book) Sucks

Any advice for my MacBook Word / Excel / Powerpoint woes? [more inside]

## Help me optimize a list in Excel.

Help me optimize a list in Excel. (Excel gurus welcome!) [more inside]

## How do I COMPLETELY turn off Excel autoformatting?

How do I completely turn off all autoformatting in Excel? [more inside]

## Help for Excel

Excel help please: Is there a keystroke for Insert->Name->Define? Can I make one? How? I use this a ton in my work.

## I need a fix for an excel formula recalculation error.

I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]

## Oh. My. Code. Excel VBA Needs

I've created a button in Excel 2002 that runs some VBA when clicked. Works great. I've emailed the spreadsheet home and opened it with Excel 97 and clicking does nothing.
When I run the subroutine from VBA editor, it works fine. So, what gives? Why won't this work in Excel 97 and what can I change so that it will run in Excel 97 and beyond?
I've pasted the subroutine into the Extended box. Oh, and I'm really an infant with this, so please try and communicate on that level. [more inside]

## Comparing names in excel

How do I compare lists of names from two excel spreadsheets? [more inside]

## Excel pop-up won't leave

There's a little pop-up menu beside a cell in Excel. I cannot click it open to see what it's trying to offer, and I cannot "clear all contents" in that cell to get rid of it! [more inside]

## Split up my file! Argh!

I need help reformatting a .lst file for use in Excel (I think)... [more inside]

## Lots of data

Dealing with a big Excel database. [more inside]

## Champagne scheduling app on a beer budget.

OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]

## Excel master needed...where to find one?

I run a computer service. I have an issue that is a bit outside the bounds. I have a client who has been using an Excel spreadsheet to track his portfolio. It is pre-formatted for him to enter data and the formulas are all there.
Just recently, it started calculating some things incorrectly.
The person who originally set it up just passed away earlier this year.
We need an Excel expert that can look at the file and don't know where to begin to find one. Checked the local community college but no dice. All ideas or pointers are appreciated.

## Excel: moving data from multiple columns to a 2-column format

Excel / VBA help needed: moving data from multiple columns to a 2-column format [more inside]

## Understanding external references in Microsoft Excel?

It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]

## Way to automate string creation from values in an Excel spreadsheet?

Way to automate string creation from values in an Excel spreadsheet? [more inside]

## Break Excel password?

Is there a way to break/uncover/crack/hack an Excel spreadsheet password? [more inside]

## How to search an interior matrix/array and lookup a corresponding value in Excel?

Excel Powers Active! Vague Excel spreadsheet lookup problem inside. [more inside]

## File listing help

How can I easily get all the music files on my computer listed on to an excel spreadsheet? [more inside]

## Excel Hours Mins

Excel Filter: I need to convert a wallop load of cells that are in decimal format to hours & minutes format. Please. More Inside. [more inside]

## Pre-1900 dates in Excel?

Is there any way to make Microsoft Excel recognize dates before 1900? [more inside]

## Excel help needed

How do I work with (merge) these 2 Excel Spreadsheets? [more inside]

## How to fix the number format of an Excel file

Is it possible to stipulate that a Microsoft Excel file will always display a specific number format e.g. the Anglo-American decimal point, regardless of the local settings of the computer where it is viewed? [more inside]