LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelmybelle
 
Posts: n/a
Default How can I remove values under a certain value from a table?

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).
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel calculate populate table using row/column values & calc's on other sheet? wildswing Excel Discussion (Misc queries) 1 January 26th 06 06:18 AM
Populating a table based on values in another table Bri Excel Worksheet Functions 0 January 26th 06 01:23 AM
How do I remove items listed in a pivot table drop down list box Hart165Hour Excel Discussion (Misc queries) 3 March 16th 05 04:19 AM
How do I remove the individual subtotal lines from a pivot table.. leo Excel Discussion (Misc queries) 2 March 16th 05 03:19 AM
how to remove "(All)" in a pivot table using VBA Excel Discussion (Misc queries) 1 March 10th 05 01:34 PM


All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"