Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find X number of smallest values in a range | Excel Worksheet Functions | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
To find duplicated values in a range | Excel Worksheet Functions | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
How do I find the two lowest values in a range? | Excel Worksheet Functions |