Find all same values from defined range
 

Hello!

Does anyone know, which is the best/easier way to find variable defined
values from worksheet. I can find dublicates, but it doesn't fit in this
situation.

An example:

I want to know which cells contain value "missed" and Excel highlights all
those cells some way. Maybe some lines and arrows between cells would be
extra fabulous.

Is this even possible?

Many thanks, if someone could give some good advice.

JG

Find all same values from defined range
 

Maybe datafilterautofilter, select custom and contains missed


--


Regards,


Peo Sjoblom


"Jeff Gordon" wrote in message
...
Hello!

Does anyone know, which is the best/easier way to find variable defined
values from worksheet. I can find dublicates, but it doesn't fit in this
situation.

An example:

I want to know which cells contain value "missed" and Excel highlights all
those cells some way. Maybe some lines and arrows between cells would be
extra fabulous.

Is this even possible?

Many thanks, if someone could give some good advice.

JG

Find all same values from defined range
 

"Jeff Gordon" wrote in message
...
Hello!

Does anyone know, which is the best/easier way to find variable defined
values from worksheet. I can find dublicates, but it doesn't fit in this
situation.

An example:

I want to know which cells contain value "missed" and Excel highlights
all those cells some way. Maybe some lines and arrows between cells would
be extra fabulous.

Is this even possible?

Many thanks, if someone could give some good advice.

JG



"Peo Sjoblom" wrote in message
...
Maybe datafilterautofilter, select custom and contains missed


--


Regards,


Peo Sjoblom


This is not the key to solution, because it will sort only columns. Range
is columns and rows at same time. on the other hand, the sorting is not an
answer at all.

Thanks anyway

JG

Find all same values from defined range
 

Select all cells and EditFind

What: missed

Find All

In the found dialog box Hit SHIFT + End + Downarrow to select all found cells.

Hit the color picker icon and select a color.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 19:20:59 +0200, "Jeff Gordon" wrote:




"Jeff Gordon" wrote in message
...
Hello!

Does anyone know, which is the best/easier way to find variable defined
values from worksheet. I can find dublicates, but it doesn't fit in this
situation.

An example:

I want to know which cells contain value "missed" and Excel highlights
all those cells some way. Maybe some lines and arrows between cells would
be extra fabulous.

Is this even possible?

Many thanks, if someone could give some good advice.

JG



"Peo Sjoblom" wrote in message
...
Maybe datafilterautofilter, select custom and contains missed


--


Regards,


Peo Sjoblom


This is not the key to solution, because it will sort only columns. Range
is columns and rows at same time. on the other hand, the sorting is not an
answer at all.

Thanks anyway

JG

Find all same values from defined range
 

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select all cells and EditFind

What: missed

Find All

In the found dialog box Hit SHIFT + End + Downarrow to select all found
cells.

Hit the color picker icon and select a color.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 19:20:59 +0200, "Jeff Gordon" wrote:





Okay, it´s fine and Thanks this far. Is there any chance to get them wired
some way?

JG

Find all same values from defined range
 

"Jeff Gordon" wrote in message
...

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select all cells and EditFind

What: missed

Find All

In the found dialog box Hit SHIFT + End + Downarrow to select all found
cells.

Hit the color picker icon and select a color.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 19:20:59 +0200, "Jeff Gordon" wrote:





Okay, it´s fine and Thanks this far. Is there any chance to get them wired
some way?

JG

Multiple VLOOKUP was an answer in my case. Thanks for helping me.

JG