select data

AllenL · Mar 22nd, 2002, 08:23 AM

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

Tom Schreiner · Mar 22nd, 2002, 08:26 AM

Have you tried the auto filter?

Dave Hawley · Mar 22nd, 2002, 08:30 AM

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 · Mar 22nd, 2002, 08:54 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 08:23 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 22nd, 2002, 08:26 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Have you tried the auto filter?

Mar 22nd, 2002, 08:30 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 22nd, 2002, 08:54 AM	#4
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Thank you very much guys. Auto filer is new to me and I find it very useful Thanks again