Is there a way of selectively importing data - have a csv file that is around 126 million rows and 3 columns. The third column will be a number between 0 up to around 1,000.
Is it possible to request that a row is only imported if, say, the value in the 3rd column for that row was less than...
I have a 2010 Excel file with three tabs, one that only has any data on it... and it only has 26 rows and 34 columns that have any data??? the file size is 5.2MB??? same file saved as 97-2003 is more than half the file size smaller at 2.1MB??? Can anyone help! Thanks, Sybo2
First . . . I did search the Internet, found some similar-sound problems, but none of their suggestions worked. . . .
I am using Excel 2007 on Windows Vista (Home edition). For months I have been developing some VBA code for Excel, with no problems. All of a sudden, I constantly get the...
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.