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.