| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
or(exact)) function does not work
Help!
I am trying to compare a list of words to an array of words. so example: john to great dog john To do this I am using the function =or(exact(A1, B1:B3)) As told to do by help... but this does not work if the word you are searching for is not the first cell in the array..... Please help on why this is..... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
or(exact)) function does not work
Hi
enter this as array formula (with CTRL+sHIFT+ENTER) -----Original Message----- Help! I am trying to compare a list of words to an array of words. so example: john to great dog john To do this I am using the function =or(exact(A1, B1:B3)) As told to do by help... but this does not work if the word you are searching for is not the first cell in the array..... Please help on why this is..... . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exact Function | Excel Discussion (Misc queries) | |||
| How do I make an exact copy of my bill work sheets to year 2010 | Excel Discussion (Misc queries) | |||
| OR(EXACT(Cell; Range)) does not work properly | Excel Worksheet Functions | |||
| How do I work out people's exact ages from their Dates of Birth? | Excel Discussion (Misc queries) | |||
| EXACT function | Excel Discussion (Misc queries) | |||
Linear Mode
