You have more responses at your other post.

GEM wrote:

I filter all the cells that have the name JOHN DOE on column A, so now I
only have A1, A4, A7, A15, A21 & A42 showing because all of them have the
name JOHN DOE. When I add the number 1 then the number 2 to B1 and B4 and
then select them both and drag them down, it won't continue as 1, 2, 3, 4,
etc. it turns them all to 1.

How can I drag the numbers down and get, 1, 2, 3, 4, 5, etc...

--

Dave Peterson