View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
noyau noyau is offline
external usenet poster
 
Posts: 20
Default How to take out a list from a list

There is a table of 8 columns and X rows from A1 to G(X). I am entering new
values everyday. I am trying to form a secondary list making use of values in
column C (which are; A,B,C,1,2,3,4,5) as reference. I would like to have all
rows containing "B" in column C to from a new listing in the next sheet.