dear all, i have table with 100.000 rows... column a (no) column b (customer) column c (cities name) 1 reza new york 2 bob ...

I have created a list called 'FullName' which will be added to with a macro. When using this list in a cell using Conditional formatting is it possible to...

Excel 2007 - Yesterday I had 2 users call with the same spreadsheet problem. After creating a formula, they copied it down with the right click copy and...

I'm changing email programs and am trying to import client data. The old program will allow me to export this data as csv only. The new program will import...

When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as Avg 0.286253661284266 but I only want it to 2 decimal points! The D30 cell...

I forgot the password I set to protect an excel file, how can I recall the password to unprotect the file? thank you in advance MG

Update to previous!!!! It is the date I am having trouble with? the previous formatting offered the diplay option of Tuesday March 9, 2010 and would...

Trying to make my pivot tables more useful by customizing my own formulas. I would prefer to use the following formula within a pivot table but can't seem to...

I am trying to weight a series of performance indicators which have been created as rankings - sales / profit / etc.. i can rank on perfrmance easily but i...

What is the formula to count Red highlighted cells in the range F2 thru S412? I also need formulas to count separately Yellow and Sky Blue cells in the same...

Sure would oblige a message box returning the full path of a file browsed. -- Thanx & Best Regards, Faraz!

Is it possible to freeze the size and locations of Charts in Excel 2007? The size and location on the worksheets keeps changing. I have tried the Properties...

Hi, In the Excel sheet, I've clicked 'Hidden' in 'protection' tab in 'Format cells' of the cell, and then I protected the sheet. But the 'hidden' cells that...

two students are using a rating scale to independently assess the quality of medical letters. They are trying to assess to what extent their ratings agree...

Hello All, In Excel 2003 I used to use DATA - IMPORT EXTERNAL DATA - GET DATA and a dialogue box would start and I could import another Excel file (well table...

is there a function can count number of word in a cell example: A B username count kok, hong, Lee chan, NG Ti, Lee

Hello, Can you help me to figure out what to change to have one record printed per sheet be the standard way my report prints. -- Thank you for your...

I have a large excel document, and I wish to know if it is possible to scroll using the mouse wheel horizontally across the page, instead of the default...

Hello, I have entered a SUM formula. The cell shows 0 value for all the rows. When i click on the Function Argument, i can see the actual result. How can i...

am trying to mail one page from excel 2007 but keep getting message 'check mail installation'. have tried suggestions on the help site without success. am...