One other way ...
1. Type the range in the namebox, eg: D1:D8000,
press ENTER to select the range
2. Paste the top cell's formula, ie that for D1, into the formula bar
3. Press CTRL+ENTER to fill down the entire range at one go
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"REBANEEDSTOKNOW" wrote:
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!