(Excel 2000) we have spreadsheets with Names that somehow have square boxes in front of them that we cannot delete with the macro we use, or with the manual...

There is a function in Excel called Subtotals (accessible via the Data menu) which is supposed to group together and subtotal rows of data. The function can...

the function =STDEV(1.4434,1.4434,1.4434) gives 2.98023E-08 (at least on my computer using Excel 2002, sp3) Is this just rounding error due to IEEE double...

Hello, I use Excel 2002 and I will appreciate having a detailed procedure of creating a new user defined function and storing it in the personal.xls...

Hi, How can I highlight cells in a list of numbers on Sheet1 where the number of occurrences of that number on Sheet2 is not equal to 1? Sheet1 has a list...

I would like a formula that can equate a letter with an number, add the given range, but also not do anything if there is a blank cell... for example if i...

hi if you could help me with this it would be great, i have tried to use the nested IF condition to insert numbers in a column beside a column of country...

I have a worksheet with about 650 rows of data. I am trying to sort by the leftmost column, a mixed-number column in basically a list of part numbers. I have...

Is it possible to copy and paste a conditional sum formula to a different cell location and then change the = to value in the IF( portion of the formula? I...

I'm trying to use excel as a compliance tool. I have one cell, where the name is manually typed in cell M17. For this example, let's say that the name used...

I have created several marco's in Excel and they work great when you map to the drive they are on and run them normal. If you try to run them through Explorer...

How to get a calculation or formula to insert its result in another cell? eg say I want B1 = A1 + 2. The standard way is to put '=A1 + 2' in cell B1. I want...

I am looking for a way to show a 3-Dimensional Stacked Bar (column). Is there a way to do that? The top parameter (construction site) has six sub-parameters...

is their a way to sort a work sheet or book then do a data sort without unprotecting the sheet or book

After blocking text I can use Ctrl+C to copy but the copy command under the edit menu is always greyed out. Cut and paste are fully functional.

How can I customize the menu that appears when I right-click the mouse on a cell on Excel worksheet? For example, I want to add the Auto Sum function on the...

Hello All, Okay..check out this formula =IF(ISERROR(VLOOKUP(M4,Test,10,FALSE)),"",VLOOKUP (M4,Test,10,FALSE)) What this does is say okay look at this number...

WOW!! I am completely stumped!! Here is the formula...

Please help..... =IF(ISERROR(VLOOKUP(G4,Tivoli,5,FALSE)),"",VLOOKUP (G4,Tivoli,5,FALSE)) returns the word Infrastructure...... I want to use the mid...

I tried to explain this one yesterday but I don't think I was clear so I will try again.... I have columns on my worksheet that calculates the duration of a...