AutoFilter then dragging down.

[GEM]

I am trying to filter information I have on a worksheet and then adding
numbers to a column right next to the info and dragging it down to have 1, 2,
3, etc. It turns all the numbers I dragged down to 1. Why??

 

[Ivor Davies]

Are the numbers you're adding in the column to the right a formula reference
to the filtered list? If so Excel is probably treating the filtered list as
a named (fixed) reference. That is instead of referencing an individual cell
in the filtered list it is referencing the entire list. To fix this I
usually just specify the cell reference in the formula. Hope this helps.

 

[Ivor Davies]

Just thinking - you may have calculation set to manual. Go to
Tools>Options>Calculation then make sure the "Automatic" button is selected.

 

[GEM]

No, when I filter and then drag it won't drag continues numbers down.

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]

Show all your data
Sort the data so that you have it grouped the way you want.
Put the numbers in.
Re-sort the data to put it in the order that you want.