| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function limitation
All -
Using the following function..=MATCH(CONCATENATE("*",A9,"*"),D3:D21,0) The D3 - D21 range consists of text only. Some cells contain 300 + characters and some less than 100. The function works fine on the lower character count cells but not on the higher. Is there a limitation in the function(s) I'm not aware of? -TIA -Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
