| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help finishing array formula!
I need the following array formul to only select cell values longer than a
string of 4. The array works-but I cannot get it to discriminate and only select values of 5 characters and larger. =IF(ISERROR(LARGE(D6:D14,ROW(INDIRECT("1:4")))),"" ,LARGE(D6:D14,ROW(INDIRECT("1:4")))) Ex. Col A 4444Don't show 45656Show value 123Don't Show 45689Show value Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
