when I try to open an excel file, it wants to run virus scan and it takes forever to open the file. Is there a way to disable the virus scan and just open...

Hi Is there anyway of removing the auto filter from certain columns. I only want it on the first two and want to be able to remove or hide the button from...

I have been doing data analysis and I want to create an x-y scatter which represents the strain values on the horizontal (x-axis) and the load on the...

Hi all got a non static list like this 1 List wanted color xxxBxxx1 light grey xxxBxxx2 light grey xxxBxxx3 light grey xxxDxxx5 dark...

Hej, jag har en fakturablankett i Excel och önskar att varje gång jag skapar en ny faktura(genom att öppna ett Excel malldokument) så ska nytt...

I have a spreadsheet set up where column A has either Recall, Retail or VSR in it, and column B has either Yes or No in it. I need to be able to count how...

I have huge data containing running project details, wherein I need to list-out Names of Projects under various Managers. So a manager can have 1 or 2 or 10...

Hi, Thanks for looking at my XL problem. I have a spreadsheet below which I want to use to give a basic sales forecast. In Col G I have products. I also...

I have two cells that I want to sum, but only if they meet a certain criteria. However, if they don't meet the criteria I don't want them summed, nor do I...

I need to change the formatting of a cell from a dollar amount to a format that appears DDDDDDDDCC (D=dollars and C=cents). When I custom format the cell to...

Hi, I am using a form to enter data to Excel 2007. Private Sub nr5_Change() Dim nr5 As Variant nr5 = Format("#,##0.00") End Sub The standard format does not...

Can anybody help me with the following problem. I’m creating a spreadsheet that shows expenses for a business structure. The expenses are recorded as they...

Got huge list of responses to survey - they a very good, good, not good, not good at all. Problem I have is that when I try to count how many instance of...

I am very used to using Group and Outline. In Excel 2003, it used to often tell me "Cant shift object of the sheet.." or something to that effect, which I...

Hi, I have One master excel file which have all the vehicles nos. and comments and other which I am generating on daily basis for vehicles nos. Is it...

Hi , I am using a Formula from Chip Pearson that will give the WEEK No. (ISO) for an entered date. Is there a way to enter a WEEK No. (and year) and get the...

In my mind , the notion "between" should mean that the limits used to define "between" should not be part of the resulting answer. Seemingly not so with...

I have multiple unique identifiers (item) in each cell of a spreadsheet, separated by a comma and space, and I need to find a way to separate them so there...

How do I set the background colour of a cell to Red if the value of any cell in a range is greater than, say, 110?

I am new at sorting large files in Excel 2007. I have multiple columns, but need to find the duplicates and process them. I would like to find a way to: 1....