Every time I enter a number into a sheet (all my sheets) it adds a zero at the end automatically, e.g. 12 becomes 120. Now I can stop this by typing 12.0. I've...

I have a list of radio stations in column A in my destination sheet. (KBXR,KOTZ,WFUV, etc.) I import numbers weekly that correlate to each station. In order...

I like the "Auto Filter" feature, especially with a "Subtotal" at the end of several columns of my spreadsheet. What I need know is something like a...

I constantly use the functions/commands: Format/Column/AutoFit Selection. Is there any way to make a column automatically widen to fit contents as...

Hi: I have a spreadsheet with 10 columns and about 200 rows. Each row is a record. There is a total row in row 201 that performs basic calculations (like...

You can probably use something from this site =SUMPRODUCT((I2:I100=A2)*(E2:E100="S")) http://www.cpearson.com/excel/duplicat.htm -- Regards,

Hello, I'm trying to automate an excel spreadsheet to track the employees' resolution time to problem solving. I have a standard table where it states the...

Hi: Why is it that when I edit a formula (within the formula bar) several times trying to get it to work, (the formula palette appears and gives the answer I...

Hi Have Excel 2002 installed on a Windows 2k Pro machine. When I click in a cell the program acts as though I have held the mouse button down, selecting all...

Aviation Navigation Formula needed for calculating Distance/Heading from Latitude Longitude. I need to calculate distance/heading from hundreds of waypoints...

i cannot remove the password protection to open a excel file. i can open the file but cannot unprotect it. can anyone help ?

I'm trying to enter 3 ranges with 3 different ranges into a countif - but can get it to work. Not really sure of the layout. ...

I need a formula to count the # of rows where the contents of Cell A2 are in column I and column E contains "S".

I have up to 400 rows of data imported into a work sheet coming from a data logging device. The work sheet has functions to test each set of data which forms a...

Hello, Please let me know if any method is there in excell 2000 for cutting a cell from one worksheet and pasting it simultaneously onto other worksheets of...

Hi, the best way to explain this problem is to show you the table (attached) and its accompanying format that I would like to migrate the data from. I'm sure...

Hello! Please, I need a formulae to calc next: A B 10 1 2 3 ___ 60 (1*10)+(2*10)+(3*10)

Can you open the file(s) in xl? What version? If you can open a file, try to copy the data into a new workbook. Try to open the file into the newest version...

How to calculate a number of days between two dates, exclude the day's off and knowing that working day's should be 6 day's per week ? Thanks a lot

I use the advanced sorting option with pivot tables so I can limit the records to the top 20 items in the table. The problem is that I always get more than...