Hello, I have a spreadsheet with formulas in column "J".
I'd like to delete the rows that are "OK" in the "J".
How do I do that?
Other ways I tried did not work!
Thanks
See the attachment.
Hello, I have a spreadsheet with formulas in column "J".
I'd like to delete the rows that are "OK" in the "J".
How do I do that?
Other ways I tried did not work!
Thanks
See the attachment.
Last edited by marreco; 01-29-2012 at 08:40 AM.
Hi
I think that you can do it, using, maybe, the simplest way.
Auto Filter>>>filter by "Ok">>>>delete all>>>>>>>Done!
Hope to helps you
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There is a possibility to automate?
...Really i am not sure...
I'll take a look after my lunch! Now is Lunch time for us.!
Hi Marreco,
You can use following code to achieve the desired result:-
Regards,Please Login or Register to view this content.
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
It was perfect!
thank you!!
You are welcome marreco...
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks