Hi All,
This is my first thread. I am really bad with excel formulae so please help.
Have a 8000 line spreadsheet. I need to find zero values in column D AND blank values in column E and then delete them.
Pls suggest an easy and quick way.
Thanks
Hi All,
This is my first thread. I am really bad with excel formulae so please help.
Have a 8000 line spreadsheet. I need to find zero values in column D AND blank values in column E and then delete them.
Pls suggest an easy and quick way.
Thanks
You can't delete a row using a formula, so you would need a macro to do that (which might be even more daunting to you than formulae).
However, you can do it manually - just apply autofilter to column D and column E then select the visible rows and click the <delete> icon, then remove the filters.
Hope this helps.
Pete
Hi
It can also be done by using macro too... what will you prefer?
If you want macro then pls upload sample file...
Click *, if my suggestion helps you. Have a good day!!
Thanks Pete and jraj.
I used the filter, works just fine without any formula!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks