I have two columns ,one with 1000 numbers (A) and one with 1700 (B).  Column
1 is the correct column.  I want to compare columns A and B and move those in
B that don't match or appear in A to a third column.  End result should be
#'s in A and B  should match and a third column ...

I am working on a template for stats, when i enter time in mm:ss it shows and
calculates incorrectly. can anyone help in solving this problem
thanks

I need to grab the contents of a cell and put it into a formula.  I would
have a fixed location into which I type an integer (say, 23). In another cell
would be a formula that would use the contents of B23, as in B23/12.  The B
is a constant, as in $B[integer_in_fixed_location].

I have a workbook in which I would like to enter important model and serial
numbers on Sheet 2.  If I enter any of the model and serial numbers from
Sheet 2 on Sheet 1, I want the Font of those model and serial numbers on
Sheet 1 to become red and bold.  However if I do not enter ...

I would like to protect, lock or keep someone from accidently deleting a
formula in Excel 07. I do not want to password protect the workbook or
worksheet.
We need to enter data into the cells and then select most of the worksheet

I need to be able to copy content from one worksheet (contests) to another
worksheet (current) if Status = Open.
On Contests column A is Status.
If Column A1 = Open, I want to copy content from B1:I1 to worksheet Current

I need to compute age/years of experience etc of our associates. The results
have to be in completed years and completed months till date or as on a
particular date.
The first column has the name, the next the date of birth in date format and

Hi, I am using Excel 2002 and noticed that one of my spreadsheets lettering
for columns is "A", "B", "C", "D", "F", for some reason column "E"
disappeared. I  know that I deleted and inserted columns numerous times but I
believe that the sequence is rearranged for the new / ...

I am trying to design a workbook so that when I enter an "R" or "L" in a
column on Sheet 1, the appropriate column with Category L or Category R  in
Sheet 2 gets a 1 underneath it.  Do you have any ideas about how might be the
best way to accomplish this?

I am using the same formula format in 64 cells, they all return the correct
results except for one. The format is identical, refferanced cells are
correct in ID and contents.
There is no explination why the results are different in this one instance,

hi, I run into this problem where I have hidden rows 1 - 3 and now I can't
seem to unhide them.
I found the below in online help. however, it still does not unhide the
hidden rows.

I have a column of mumbers in which few numbers are filled with blue color,
can I give a formula to add the cells that are colored?

I am trying to set up payroll calendars and can't figure out how to copy D5
into D10, D15, D20 etc without having to cut and paste.

example
col-A   COL-B      COL-C        COL-D       COL-E
AA        1              C/S           F            05.APR.08
AA        4              S/S           S           02.MAY.08

I have a cell where in I need to enter an alphanumeric strictly as under
AAAAI7504G
The rule is : First 5 should be alphabets, next 4 should be numbers and the
last again an alphabet.