Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if item is in a range of items
I'm wanting to check if a value in one cell is in a range of other cells.
(For example, A1 contains "dog" and B1 through B10 contains a list of various animals. I want to know if "dog" in the list.) I know I can program a loop and compare item-by-item, but I'm guessing there's a couple of one-liners that will do it more efficiently, like loading the range of values in a collection then inquiring if the single cell value is in the collection. Cannot seem to find anything in Help to steer me in the right direction. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find all item codes for all items under one category | Excel Discussion (Misc queries) | |||
remove items from listbox together with add item | Excel Programming | |||
number of items fit into item | Excel Worksheet Functions | |||
determine if Pivot Table field item is hidden | Excel Programming | |||
How do i sort items using two rows per item in Excel? | Excel Discussion (Misc queries) |