Thread: filter 10 items from a list of 100
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default filter 10 items from a list of 100
Hi Bill,

Which 10 do you wish to use?
One possibility with your data in A1 to A100 put this formula in B1 and
copy down to B10.
=INDEX(A:A,ROWS($1:1)*10)
This will place every tenth value into column B.

HTH
Martin


Reply With QuoteReply With Quote