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
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
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.
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
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.