Hello All! I have been using a sort on a helper column of random numbers to randomize a data set but I notice that the column of random numbers changes when...

I need to create a chart that is divided into quadrants and have a color associated with the area. If you fall into a certain data range i.e., +/- 0 to 10%...

How do you correct this ?

I would like to create a worksheet in Ecxel 2007 that can be shared as an email with the worksheet as the body of the message. I've been able to do this with...

For some reason none of hte formula in a spreadsheet are working. The spreadsheet is on a netowrk and when others open it, the formulas work. When I open...

If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell?

where can i find a free capex template and justification template

Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums look like...

Have you received any possible solutions? I'm having the same issue with Notes R5 & Excel 2002 SR2. Dan. I'm trying to use the "Send to Mail Recipient...

With Excel 97, is there a way to have rows repeat at the "bottom" of every page? This would be more information than would typically be in a footer. I know in...

Within Excel I have code that works well when sending mail via Outlook but not so when the email server is Lotus Notes. My Place of Work is entirly Lotus...

I have developed a rule for a column of data. =$ak$7:$ak$11 =$ak$4:$ak$6 I want to repeat this same rule to adjacent columns, AL thru AS. Then I want to repeat...

I am having difficulty in Excel 2000 applying the "single accounting" underline to a cell with the percent format. Applying the single accounting underline to...

Hi. I have a column where I have names and surnames. I want to put name in one column and surname in anoter column. In order to do this, I use Text to...

I have an Excel2000 workbook on a shared drive; users fill out some cells in the excel file and are supposed to do a "save as" to save it as a separate file....

How can I insert a drop down calendar to a cell in a worksheet?

When doing a MS Query return to excel, I get the message that is the subject of this question. I thought I saw something about a way to have the data placed...

Is there any way (in Excel 2003) in which a formula in a locked cell of a password protected worksheet can end up corrupted, without the sheet having first...

I have a Query fetch_from_bob that moves data (collapses records,unique key search, etc...) from excel spreadsheet "bob" to excel spreadsheet "fred". Fred and...

I want to wite sample accross my spreadsheet however do not know how to do this