I used this website to help me set up the validation to stop duplicates,
which worked perfectly until I got to the cap of 2000.
http://www.ozgrid.com/Excel/prevent-duplicates.htm
Now I cannot change the range to go any higher than 2000 no matter what I

I have a workbook set up jan - dec, i want get info from these pages
consolidated onto1 page. I need the rows that have certain blank colums only.
example, jan has 5 rows of names, row 3 & 5 are the only ones that have
column f thru h blank. these are the only rows i want on new ...

I have an IF statement based on 2 criteria in an OR statement.
....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.
I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

I had a completed worksheet that was working properly.  Somehow, the sheet
was changed so that every cell displays the formula instead of the result.  
Date cells display the absolute date number.  I don't know how it happened,
and I don't know how to get it back.  I can not ...

I want the worksheet to automatically turn a cell red when the date is past
due.  Can some please help me with this?

hi i have 200 tracking numbers a lot of them are repetitive how to i filter
them out

I am looking to create an IF function, but I need to draw information off
another sheet, is this possible? And how do I create the function with
between values too?
Example of what I am trying to do:

I have a worksheet which lists each officer and the accounts they manage.
Thanks to Adilson Soledade I was able to create worksheets and name them
according to cells created from filtering the unique values of the IO
column which contains the officer names on the main worksheet.

IN MICROSOFT EXCEL, IS THERE ANY FORMULA BY WHICH THE 'FIGURE' THAT APPEAR IN
A CELL CAN BE TRANSLATED TO 'WORDS' IN ANOTHER CELL? E.G. IF CELL A3 CONTAINS
195, CAN WE MAKE CELL A5 TO READ 'ONE HUNDRED AND NINETY FIVE'?

On a large worksheet with approx 7000 rows which will be filled in as time
goes on, I have numerous formulae which refer to ranges; i.e. B7:B7000.
I would like to speed up calculations by having excel only calculate down to
the last cell which has data in it rather than all the ...

I am trying to average cells in multiple worksheets.
Let's say that in:
Sheet1 Cell A1 = 4.40%
Sheet2 Cell A1 = 2.65%

how do i use the create a list feature in Excel 2000"

Hey guys,
I have tried a formula to count the sick leave taken but i realize
that my formula is wrong b in my company the balance of my sick leave
will be restarted each time the employee completes the year so i

I am trying to convert USD to pesos for a school project in my spreadsheet. I
can't find a way to do this without changing my default settings--Help!!

I have a workbook that I am trying to use 2 option buttons that use macros to
copy and paste data in one cell in a separate worksheet to 7 other cells in a
row in the same worksheet.
One option button is named CASH and the other is named CREDIT and I want the