there is no formula to do this. But you could use Filter from the Data menu that would hide those rows.
If you want to delete them, you'll need a macro. Or you can easily do it manually after sorting your table.
there is no formula to do this. But you could use Filter from the Data menu that would hide those rows.
If you want to delete them, you'll need a macro. Or you can easily do it manually after sorting your table.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks