It will. Just copy it down. But change the formula to:
=COUNTIF($A$1:$A$7999,A1)1
Then copy.

The best way to copy formulas is to grab the fill handle (the small black
box on the bottom right of the cell). Then drag it down the column. Excel
will adjust the formulas as it goes.

One trick to fill an entire column is to double click on the fill handle.
This will fill down the the last cell in the adjacent column (C). It works
great if you have good database organization.

If this doesn't work for you, post back, with specifics of how your data is
organized. Someone will come up with a shortcut.

Regards,
Fred


"REBANEEDSTOKNOW" wrote in
message ...
Ok, I'm trying to have a function apply to an entire set of information.
What I need is for the function to adapt to the row it is in... like, when
I
enter this...
=COUNTIF($A1:$A7999,A1)1
...in D1, it references A1. But then in D2, I need it to switch to...
=COUNTIF($A1:$A7999,A2)1
...where it references A2

I guess what I'm asking is how can I automate it so I don't have to go in
by
hand for 8000 rows and change the information. And also, how can I apply
the
formula to the whole D column, without having to copy and paste it into
each
box. Thank you!