Sorting

[Jewels4juls]

I work in a hospital in the billing office. I have over 4,000 accounts
on one worksheet, and I want to audit every tenth account. Is there a
formula or something in excel that will go through the worksheet and
pull every tenth account on it's own, or do I have to manually count
them myself?

 

[Gord Dibben]

Place this formula in row 1 of a column and drag/copy down as far as you need.
It will return data from every 10th cell starting from row 10.

=OFFSET($A$1,10*ROW() -1,0)

or this if you want A1, A11, A21 etc.

=OFFSET($A$1,ROW()*10-10,)

Gord Dibben XL2002

 

[Guest]

You can write a macro that can do your work. It will read data from the top and will write 10th (or whatever number) in somewhere. I am trying to write this macro. If you want it please let me know.