View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default How can I remove values under a certain value from a table?

Take a look at Data Filter AutoFilter Custom, on the column of
interest, then use "Greater than" or "lesser than" for a cirteria......then
copy and paste the filtered results to another sheet.


Vaya con Dios,
Chuck, CABGx3



"excelmybelle" wrote:

Hi. I have a table that contains data from row A-I. The values in row G
vary from 0 and up... what I would like to do is tell Excel for any value
that is below .05 in row G, remove that line from the table and paste that
data below the entire table (starting a new table of values that are below
.05).