Results 1 to 5 of 5

Tweak array IF(ISNUMBER(FIND formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Tweak array IF(ISNUMBER(FIND formula

    Hi all,

    I have a formula that is not quite capturing what I need it to....

    Formula is:

    =SUM(IF(ISNUMBER(FIND(" "&$R2&" "," "&B4:H4&" ")),LEFT(B4:H4,FIND(" ",B4:H4)-1)+0))
    but since I didn't creat the formula, I do not have the knowledge enough to tweak it. It currently returns part of a cells contents, summed (a number value); however, I need it to return the entire contents of the cell....

    Example:
    Currently returns: 10
    Want it to return: 10 OT L1P

    Spreadsheet attached - thanks
    Attached Files Attached Files
    Last edited by Greed; 10-25-2011 at 12:59 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1