how to filter cells where are comments...

A

antares

cDear All,
I have following question:
suppse I have cells where I wrote revisions of some documents eg : 01, 02,
03, but suppose some "02"s or some "01" or some "03" are latest revisions of
some documents...how do I filter among these all sells that to have only
latest revisions?
I thouhgt may be to put a comment "latest" and then somehow to tell excell
to filter out only these cells with "comment"....

Any ideas?
Thanks for help
 
G

Gord Dibben

If you know which 01, 02 or 03 is the latest revision, just add a helper column
and type in "latest".

Filter on "latest".


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an Excel formula to show the highest letter in a row? 1
Filtering by newest date 2
Date / Time Filter 2
Finding a maximum/minimum date in 2006 5
Excel List functions and linking cells 2
Lookup part of a cell's contents and return value of entire cell 2
FILTER FORMULA 1
How to Show SUM of field value in other column 4

Top