View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kilo kilo is offline
external usenet poster
 
Posts: 3
Default Query to delete rows or columns


date Done To Be Did
01/03/2008 80 90 Friend
02/03/2008 42 80 friend
02/03/2008 20 70 Boy
04/02/2008 89 90 Friend
05/02/2008 90 90 Boy

In the above, how can i write a simple formula or query to delete a row
whenever Boy is seen in a cell?