Note: I have uploaded a sample spreadsheet with the problem and the required results.
I’m trying to get ISTEXT to search a range of cells in the same column but it will not work. I use text as numbers and would like the result to search looking for 1-* (*is a wild card). The result should be “8”. Is this possible?
I hope you can help. If you need more information please let me know.
Mike
Last edited by mike4545; 06-24-2007 at 11:17 PM. Reason: wrong title
Hi
Try
=MAX(ISTEXT(F4:F7)*E4)
Must be array entered (ctrl, shift, enter).
rylo
Works good but is it possible to tie in the 1-* somewhere in the formula?
Mike in Canada
Mike
how about
=ISNUMBER(MATCH("1-*",F5:F7,0))*E4
rylo
Thanks so much for your help.
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks