select data

[AllenL]

Question:
I have two columns, ColumnA and ColumnB, and I want to select all the data in columnB which refer by the text "Date:" in columnA
How can I do that?
I am thinking about using Edit->Go To->Reference
But I am not sure what should I type in
Thanks in advance

 

[Legacy 98055]

Have you tried the auto filter?

 

[Dave Hawley]

Hi Allen

You could use Auto filters to filter down Column A to show "Date' only, this would only leave the correct cells visible in Column B. Then just select Column B and use Edit>Go to>Special-Visible cells.

Auto filter is under Data>Filter

 

[AllenL]

Thank you very much guys. Auto filer is new to me and I find it very useful
Thanks again