Selecting cells with their correspondig values : a very basic question but advanced for me.

[fmri2013]

Hi all,


I have a column that has 10000 words.
I also have four columns ( numbers) related to each other ( one line is specific for one of two words ) and each have 10000 values.
So it is like this as a small example:
GO 1 3
GO 2. 7
Wait 3 4
GO 3.5. 6
Wait 4.3 0
GO 3. 7
Wait 2. 6




What I want is just to select the word 'GO' ( represents 4500 of the 10000 cells) with its corresponding number or value in the other columns. I tried to use find and write Go. It works but I could not select the corresponding or value or the whole line.


Please any help on this


Thanks


AS

 

[FormR]

Hi - welcome to the forum,

What would you like to do with the cells that contain "GO" after you have have "selected" them?

 

[Lee.]

Can you just not use Auto Filter?

 

[fmri2013]

Hi - welcome to the forum,

What would you like to do with the cells that contain "GO" after you have have "selected" them?

Just move them to another sheet ( without a gap) with their corresponding values

 

[FormR]

Just move them to another sheet ( without a gap) with their corresponding values

Autofilter sounds like a good option, did you try it?