Find all same values from defined range

[Jeff Gordon]

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]

Maybe data>filter>autofilter, select custom and contains missed


--


Regards,


Peo Sjoblom

 

[Jeff Gordon]

Maybe data>filter>autofilter, 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

 

[Gord Dibben]

Select all cells and Edit>Find

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

 

[Jeff Gordon]

Select all cells and Edit>Find

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

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

JG

 

[Jeff Gordon]

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