Thread: counting rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
darryl darryl is offline
external usenet poster
 
Posts: 21
Default counting rows

I have 100 rows in a column A which are numbered 1 -100 in numical order.
After I filter a particular item in column B which results in 20 rows (and
these 20 item were scattered throughout the column), I would like column A to
show 1 - 20 in numerical order.