I am trying to find a way to compare two excel files in order to find
duplicate numbers between the two files. I am listing serial numbers and need
to make sure that there are no duplicates listed between more than one Excel
file.

I am not to good with excel but I am learning fast.
Problem, I have a worksheet, on the sheet there are 3 col's.
Col1 could contain the word "home"
Col2 contains mileage.

Can I sort worksheets in excel by names on tabs?

I hope I have the right forum. Does anyone know of a program that can
scan a piece of paper that is basically a spreadsheet into excel?
I have printed trade records that I can only view. When I print them
out to have a hard copy they look exactly like an excel printout. I

to copy one excel file to other even when is updated the other file will be
automatically updated too?
cheer

I have a table of data, and one of the columns generates a percentage.
Since it will sometimes give a DIV/0 error, the formula that generates
the percentage is:
=IF(SUM(I22:J22)=0,"",I22/SUM(I22:J22))

help required. i need to establish a top 10 from a list of 100 sellers.
for example,
seller      sales
bob          5

i would like to know if excel could seek out a certain letter eg(E) and turn
it in to a number eg e=15:00 as in what time the work shift finnishes. need
to know a formula for it tried the "if" formula. =if(a2="E","15:00") which
works untill you tell it too look in more then one ...

"Is there some VBA code with which could I autofill the column B with
some formula exactly with the same size in A while this could be
variable among the sheets?"
I have used the code:

I have several cells in a column. Each of the cells in that column contain
several codes that are seperated by a space. I need a quick way of
rearranging those codes in alphabetic order. I have a somewhat manual process
now where I copy the cell contents out of the the cell onto ...

OK Bob, Now that I have the formula, with your help and minor changes to your
formula I was able to have it show what I was looking for.
Thank you!
But I have another issue now;

I am trying to get a formula correct that basically performs the
following function:
=COUNT(IF(Data!$C$2:$C$191=Summary!B$3,IF(Data!$M$2:$M$191,"X",0)))...
But I want it to return the count of the "X"s in that column (right now

I have a worksheet
A                B                C
Days           Name         Type
5                 Kent           Computer

I have more than 10000 student records in Excel worksheet 1. One of the
columns represent the student names. But there is a list of keywords that is
forbidden to appear in the name. The list is stored in worksheet 2. How can
I perform this task in Excel?

I need a particular Cell to Highlight if it is the same (or equal to ) 8
different cells in the 1 row