I have a 4000 row and 85 column spreadsheet containing numerical data.
I need excel to delete any row that doesn't have a number greater than 100,000 in any of the 85 columns.
I just need to delete the rows which do not contain a sigle value greater than 100,000 in any of the 85 columns.
Many thanks to anyone who can help me with this
In a new column enter a formula like:
=COUNTIF(A2:CG2,">100000")=0
adjust to suit and copy down
Then go to Data|Filter|Autofilter and filter this new column for TRUE and delete those rows. Then remove the filter.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks