I have two columns with 1000+ numbers in them.  Column 1 is the correct
column.  I want to compare columns 1 and 2 and move those in #2 that don't
match or appear in #1 to a third column.  End result should be #' 1 and 2
match and a third column contains #'s that were in #2 but ...

I have a spreadsheet that covers the year daily from Jan01 - Dec31. It
includes employees names and their shift pattern.
What I would like Excel to do if possible is to count the number of
instances an employee is off .. i.e. if an employee works Mon-Fri as their

A friend has an Excel workbook that does not require the use of the = sign to
begin a formula.  In any cell on the worksheet, if a date is entered it is
formatted as a date, if text is entered it is treated as text, but when a
formula is entered it is recognised as a formula ...

Hello: I know you can show codes for formulas by pressing Ctrl +~
Can you do something similar to show codes for Validation? I have a
complicated Excel worksheet that has many variations on Validations- some are
to named cells, some are to groups of cells etc.

i am working on a spread sheet. i have set up that everytime i enter a number
the cell next to or two down adds 250 when i enter the first number is it
possible to make the cell with the added 250 turn red.

Someone please help ! Have looked everywhere.
I have created a worksheet where the user enters an item and a price and the
worksheet calcs the unit price.  Like this:
A                        B                  C                    D

In col-A ,I have dates  entered  in ascending order.
in Col-B,I have some blank cells and some entries in them.
I am trying to do this:
if(isblank(Vlookup(currentmonth date

in sheet 1  , i have in cell A1 =10
in sheet 2  , i have in cell A2 =20  and A3 =30
in sheet 3  , i have in cell A4= 60  which is the Sum of the precedent cells
NOW i would like to make a hyperlink to cell A4 in order to show me

What is the character sequence that Excel uses to represent an empty cell?  I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty.  I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an ...

I use the same custom footer on all of my spreadsheets.  How do I save it to
the preset footer list so that I don't have to re-enter it as custom on all
my spreadsheets?  

I have a spreadsheet with over 20,000 lines.  It is clothing and there are
styles, color, size, etc.
I would like to scan down column "A" and only have each style print once.  
In other words, print the style only on the first one of an entire list of

I'm using this code to import data from a specific file along with copying
some formulas in my worksheet. The way it works is that it imports starting
with the cell I've selected and then fills the rows below that. Since this
will be a daily import I'm trying to find a way that ...

I have an extremely important xls Worksheet  file, which of
course, no back up was made.  I am trying to fix it for somebody but I
keep
hitting dead ends.  I have Excel 2003 here, but if I try opening it up

would appreciate if the forum could enlighten me as to how to formulate a cell.
If Cell A1 is zero then an error text will appear on it
thank you

I am wanting to track the time spent on creating and editing a document.  I
have not been able to find where I can turn on/off this function