a. When you copy down the formula in col C,
you should see this result appearing:

MyURL
http://www.abc.com 2
http://www.cba.com 1
http://www.bca.com 1
http://www.bbb.com 2
http://www.abc.com 2
http://www.ccc.com 1
http://www.bbb.com 2

Note: If you don't see it happening as above, then the calc mode may be
inadvertently set to Manual. Press F9 to re-calc. Click Tools Options
Calculation tab to reset the calc mode to Automatic.

So when you select: 1, from the autofilter dropdown for col C,
you should get the desired results, viz.:

http://www.cba.com 1
http://www.bca.com 1
http://www.ccc.com 1

b. To copy down large ranges where the adjacent col may not be fully
populated, you could do it like this:

Click inside the namebox*, type the range: C2:C8000
Press ENTER, to select the range
*the box with the dropdown just to the left of the formula bar

Then paste your earlier formula for C2 into the formula bar,
press CTRL+ENTER, to enter the formula at one go into the entire range

Note: If the adjacent col is fully populated, you could simply enter the
formula in the top cell C2, then point to the bottom right corner of C2
(that's the fill handle, looks like a solid black square), and double click
on it. The formula will fill all the way down the entire range in col C to
the last data row in the adjacent col.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"Ivanko" wrote:
Again i have problem. Now we got formula located in C2.
And I copy formula to c3 c4 etc. to C8 where data in COA finishes end then
when i click data - filter etc. and select first option from drop down menu
which comes out in begining of CO C nothing hapends. CO A is identical as it
was on the beging....

CoA
1.MyURL (just a col header)
2.http://www.abc.com
3.http://www.cba.com
4.http://www.bca.com
5.http://www.bbb.com
6.http://www.abc.com
7.http://www.ccc.com
8.http://www.bbb.com

... one more thing. This you say copy down formula from C2. Do you meen copy
to c3 c4 etc? If this is the case it would be a problem becouse in real
document i have 8000 items in CO A so copy paste will be enormus job. Do you
have some trick to bypas that? Thanks!