Hi, thanks for any help with this if you can. I have a spreadsheet where I have calculated the time it takes to make a trip accordong to our report, and one...

I am trying to calculate the number of raw material bags I need in a batch. If I use the mround function is will round down. Is there a way to only round up?

I want a simply if then without the else.

i have an excel doc. that has hdden and unhidden information. i want to copy and paste ONLY the unhidden information. When i copy and paste it it takes...

I am trying to set up a template in Excel 2000 and would like to be able to automatically number each invoice as the template is 63opeed to a new document, can...

Hey guys, Is there a way to rename the field heading that are linked to the pivot tables, so when I click update data, it just takes on the new name. Right...

I'm using excel to outline a publicity campaign for 4 groups. I want one overall sheet with all the groups and seperate sheets with more detailed info - is...

Allie wrote... I've been trying to generate random numbers using excel's random number generator in the analysis toolpak. I'm using Uniform number...

I'm OK with understanding conditional formatting but my question is for adjacent cells. What I need to do is to enter a conditional value in one cell (in my...

i have a list of postcodes that i need to be able to pre select the zone ie 1-10 example AB = 1 PE = 3

Hi Can I change the format of one cell by placing a tick in another? Thanks Gary

I need to set up a sheet whose columns will show red when cells between .005 and 6.99, green when =7 and white when 0. I used conditional formatting to...

I need to have the Pre Set Zoom sizes of 85% and 65% in replacement of the 75% and 50% Excel Zoom Out Defaults. Is it Possible? Thanks SUNAN

Hi I am looking for a way to lookup a particular cell within a pivot table the pivot table contains 8000 account numbers down the left hand side and the...

I use a spreadsheet to track fees paid by members of two different bowling leagues. Is there an easy way to delete the information that was entered for last...

How could I make a function that would look at two columns of data, and count how many have a value of zero in both cells of a row? ie 1 2 3 5 0 0 2 ...

Why have microsoft got rid of the very useful autosave function on Excel 2003?

I have a user who cannot right click on cells. When she right clicks on a cell nothing happens. I have check in MS-Word (thinking that it has something to do...

I want to update a hyperlink automatically when the file is moved. Is that possible that when a file's location is changed and the hyperlink to that file in...