I have a database some 10 columns wide and 1200 rows deep. When I sort by one particular column it sorts BLANKS before text meaning that the data appears at...

Hi, I have all the English football league results from 1890 to present day. The data is in the format "20010821","P","home team ","1","away team ","0" ----...

Seemingly random temp files are appearing in a directory where I maintain three excel files that are accessed by multiple users. I have three excel files...

Sheet 1 below: A13 is a lookup from Sheet 2. I want the cell B13 to take this value and lookup the column 1 and enter the value into...

Sorry if this appears to be a newbie question, but how do I display a percentage figure of another cell. Example: A1 £52.89 A2 17.5% of A1 Thank you

I really need help with EXCEL. Here is what I want to do! I want it set up so I can have my credit card balances in one column, the APR in column 2, column 3...

I have a spreadsheet containing production information. I want to be able to search by date (can do this using VLOOKUP), and extract information from the same...

Please see Subject Question

Hi, Having a spot of bother here with a formula, what I need if any one can help is the following Sum of a number of fields and IF that SUM is than 10000...

Two questions:- (1) I have no problem adding words to the custom dictionary. But I don't know how to find them and delete them afterwards. I tried...

Hey All Just wondering if on ur travel's if you have come across, a template that could be used when rostering and allocating staff within either a retail...

I have a password-protected worksheet. How could I copy and paste within the same worksheet without unprotected it? Any help will be highly appreciated! Thanks,

Hi, I'm just curious to know if it is possible to have a Text Box or other information Not Scroll (Stay Stationary) when scrolling horizontal or vertical? I...

I am not sure if this is a configurable setting, or if it is whether it is done within Excel or at a Windows level, but I want to set my Excel program so...

I have started using XL2003 after some years' experience with earlier versions. On the latest version the background colour of the worksheet tabs is white...

I have placed shapes on a spread sheet. I would like to write some code so that when one or more shapes are selected and moved with the mouse, the direction...

Just wanted to know if there is a Formula that can count DIFFERENT names in a Column? eg. There may be more than 1 same name, but I dont want it counted...

Is there a way to put a check in the spreadsheet?

Hi, I have an Excel table full of information for a certain number of individuals. I've created a macro to reorganize, transpose, and arrange the data that...

Hi ther guyz............i a have small problem with the execl sheets........... my problem is e.g. i have alot of cells with a number and some text...