Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to filter cells where are comments...
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 On Fri, 16 May 2008 10:34:02 -0700, antares wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
SHow comments on an advance filter | Excel Discussion (Misc queries) | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Comments in cells | Excel Worksheet Functions |