MSFN Forum: Sort and delete rows based on criteria - MSFN Forum

Jump to content



Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Sort and delete rows based on criteria Rate Topic: -----

#1 User is offline   vayacom 

  • Group: Members
  • Posts: 5
  • Joined: 05-October 07

Posted 30 October 2007 - 06:24 AM

:hello: Hello,
I wonder if anyone knows how to:
select rows on a criteria and then delete all the matching rows.
e.j. I have an excel sheet with thousands of rows.
I want to select all rows with the criteria: 06 in column A and then automatically delete all these rows.

Thanks :)

#2 User is offline   puntoMX 

  • n00b of Masters and Vice Versa
  • Group: Super Moderator
  • Posts: 4,633
  • Joined: 28-June 04
  • OS:Windows 7 x64
  • Country: Country Flag

Posted 30 October 2007 - 11:09 AM

Autofilter will give you some options, did you play with that?

#3 User is offline   vayacom 

  • Group: Members
  • Posts: 5
  • Joined: 05-October 07

Posted 30 October 2007 - 11:21 AM

Hi,
thanks for your reply.
I did look at autofilter.
But I need to sort the column on all data starting with 06 (e.g. 06678979, 065243, etc.)
and then deleting all the matching rows.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2011 msfn.org
Privacy Policy