how to filter cells where are comments...

  • Thread starter Thread starter antares
  • Start date Start date
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
 
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

Macro to duplicate row based on cell value 0
Is there an Excel formula to show the highest letter in a row? 1
SUMIF or SUMPRODUCT or ?? 2
Filtering by newest date 2
Date / Time Filter 2
Filter Dates? 4
Comments Without Indicators; Displayed when Cells are Clicked 2
Finding a maximum/minimum date in 2006 5

Back
Top