On 2002-04-07 21:53, ms5435 wrote:
THE TABLE IS SET UP IN A 6 COLUNM(A-F) x 979 ROWS. There is acutually 5874 numbers. The table keeps on growing on a weekly basis.
Activate the option Insert|Name|Define.
Enter
DataRecs as name in the Names in workbook box.
Enter as formula in the Refers to box:
MATCH(9.99999999999999E+307,
x!$A:$A)
Activate Add.
Enter
DATA as name in the Names in workbook box.
Enter as formula in the Refers to box:
=OFFSET(
x!A2,0,0,DataRecs-1,6)
Activate OK.
Note. Change
x to the name of the sheet where your numbers are.
The OFFSET formula assumes that your data grow downwards.
In column A in a
different sheet,
in A2 enter: 1
in A3 enter: 2
Select A2:A3 and copy down until the number 99 appears.
In B2 enter: =COUNTIF(DATA,B2)
Double click on the fill handle of B2 in order to copy down the formula.
Aladin