Please help, is there any way to do this? i will try to explain..
I have 2 huge lists. One is " the Master list" which I have to extract
items that are not already listed on the second list . I don't want to
remove duplicate entries,I want to remove the duplicates completely. in

I have a large table of data relating to staff and their salary for the
month (about 500 rows). Each member of staff is coded against a cost centre,
and some members of staff have two jobs and therefore work against two
different cost centres.

How can I set the validation like this formula?
=countif(rngCheckColumn, CheckCelladdr)<=
--
gabc

I have a column of figures in a spreadsheet that has data filters
applied to it.
This column of numbers is Autosummed at the bottom.
If I choose one of the data filters, it will collapse my column of

In AT I have the sum of money for the current month - AT2:AT32
In AU I have the days left in the month (sun & mon are not included
they are the weekend).
In cell AW2 I have the formula: =VLOOKUP(0,AT2:AU33,2,FALSE)

I got some helpful reply from a user Harlan on how to move several columns of
data into one column. But because of my poor excel skill, I am stuck in the
first step, i.e. to name the selected cells as say TB1. Is there somebody who
can help me out? Thanks!

I am a novice in Macro programming.
Can you please tell me how to sort numeric data in a row and return the
column numbers in the descending order of numbers
Ex-

I have a basic formula in J6 =EDATE(I6;1)
I'm try to extend this formula from J6 to the right (every cell adds one
month to the previous), but once the EDATE([...]6;1) will get bigger than
the value in cell D4, I would like to have the formula giving me "" (empty

Im having a few problems with a some excel formula's
1:
I need a formula which will calculate a specific word in excel
(specific word=Industrial)

How can I calculate or know the exact age(Number of years)  between two dates

In order to do what I ask, I know that I am supposed to use the MIN
function, but there is a twist to what I want to do.
I have a set of data where each row is coded with a number (01, 02,
03... 10, 11, 12, etc.). Each row has a date associated with it.

Hi guys,
I'm hoping someone can help me out ! I have 2 worksheets and what i need to
do is compare 2 cols from one to 2 cols in another - if they match then bring
across a value from an X col.

Using Excell 2000, I created a cos graph using the standard format and XY
(scatter). This graph is in the horizontal form, that is the degrees from
0-360 are the x axis and the y axis contains the range -1 to 1. Is it
possible to plot the same graph and rotate it 90 degrees ...

I use a web query and need a formula which would enable me to automatically
split cells into 2 and 3 cells.
The data looks like this "24-10" or "24-20-2" or "9-8-1" i.e. it's apperance
is inconsistent as to the lenght of the numbers but always separated by "-".

I need to format twenty rows highlighting the max and min of each row, and
the only way I can find to do it is to do each row separately -- if I try to
do it for the entire thing, it either won't do it for rows or will highlight
the same numbers from the previous one.  Is there a ...