conditional deletion

[ptahl]

If there are 4 cells of data per row:date, time, price and volume and we want to delete all rows except those rows which have a volume cell value of >= 1000, how is the best achieved?
Thanks in advance.
ptahl

 

[Chris Davison]

not sure if it's *best*, as some VBA code will do it quicker, but autofiltering on that column should do the trick, leaving you the rows to delete manually

 

[dk]

To add to Chris's reply. If you autofilter using a custom criteria of <1000. Then highlight all the data and press F5 and then Special. Choose the Visible Cells Only option button. Then click Edit, Delete and choose Entire Row. That will delete all of the rows under 1000 in one go. Remove the autofilter and you'll be left with the data you want.

Regards,
Dan.

 

[Aladin Akyurek]

On 2002-03-31 06:44, ptahl wrote:
If there are 4 cells of data per row:date, time, price and volume and we want to delete all rows except those rows which have a volume cell value of >= 1000, how is the best achieved?
Thanks in advance.
ptahl

Insert 3 to 4 rows before your data.

Supposing that the data area consists of columns A thru D,

in A1 enter: Volume
in A2 enter: >=1000

Activate A4.
Activate Data|Filter|Advanced Filter.
Check Copy to another location.
Assure that the List range covers your data area.
Enter as Criteria range

$A$1:$A$2

Enter as value of Copy to, e.g.,

$F$1

Click OK.

The area starting at $F$1 is what you're looking for. You can ditch everything else if you so desire.
This message was edited by Aladin Akyurek on 2002-03-31 08:01

 

[Jack in the UK]

Hi guys

check

http://www.mrexcel.com/board/viewtopic.php?topic=3863&forum=2&4

Thiss my VBA i developed.. woth a look edit to delet not hide i guess wil do it...

Hope some option....