Can Autofill handle the following sequence? or can anyone suggest a wa
to create this sequence in a single column?
1
1251

Is there a way to validate cells in the same row has uniqe values. that is
none of the information in the cells in the same row should be the same. I
need this validation for the cells containing texts.

Is there any way to produce a truly blank cell through a calculation
My formula produces a "" in a numerical column. This is fine for Exce
purposes, but when I import into Access, the "" doesn't get accepte
because it's really text.

I want to count unique items in a list with an array formula, like th
items is in 3 columns A,B,C are from row 2 to 101. Now i use an arra
to filter out some rows in the columns of B,C & then count unique item
in Column A.

I have 9000 rows of data and I would like to use the index function to
list the top 10 or first 10 values for each of my 35 categories.  My
data is listed out as follows. (Please note that Player 1 for baseball
is not the same player 1 for football)

I am trying to combine the LOOKUP and COUNTIF functions--because I cannot
nest more than 7 functions.
Here are the two functions I have:
=IF(1-COUNTIF(G2:M2,"P")>0,1-COUNTIF(G2:M2,"P"),0)

I have a workbook with a summary tab and one tab for ever week.
I need to write a formula that looks for a value from column a, find the
sheet with a matching value in cell e4 and returns the value of cell ac1 of
the worksheet.

Can anyone help,
I need a formula to automatically put the current date into a cell if the
cell next to it is greater than 1
EG. If 'A5' = 1000 then 'B5' = Todays Date

I am having trouble coding the correct formula.  Here is an example of data
in worksheet1
A1                     B1           C1         D1            E1
DATE              value1     value2    Total1       Total2

Does anyone know how to reference data on multiple worksheets or all of
the worksheets in the same workbook? I know you can reference all data
in a given column by using A:A for example. How can you do the same
thing with worksheets?

I am trying to copy a series of cells within the same colum and paste within
that same colum without changing the formula....whenever I paste it changes
the formula to match the cells that I am pasting it in.  
For example:

I'm trying to count records if in col c(c2:c160) the value is =2 and in
col j(j2:j160) the value is between 1-7.
If the criteria matches count that as one record.
Any help would be much appreciated

I have this long list of bin locations and want to find out where the gaps
are (i.e. bin locations that are not on the list).
Our six-character bin location codes are made up as follows:
* Sector           (ex.: A), range is A-H

trying to create a cell that will choose the greatest number out of a column
of entries

I need the date in "B5" to be Static according to the date that the
data was entered into "A5" (As long as the Data is greater than 1)
EG: "A5" = 19000      (Which i type in on 21 Aug 2006) so "B5" = 21 Aug 2006
     "A6" = 20001      (Which i type in on 23 Aug 2006) so "B6' = 23 ...