View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Gordon Jeff Gordon is offline
external usenet poster
 
Posts: 9
Default 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