+ Reply to Thread
Results 1 to 3 of 3

Find Last Number

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Find Last Number

    Hello Friends

    I want to find the last number in light yellow cells the column may contain numeric or both alphanumeric.

    B1 formula is example for texts. Please find the attached excel 97 version file <Find Last Number.xls>

    thanks

    thilag
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Find Last Number

    B2 for text only:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    E2 for numbers only:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I2 for either:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Find Last Number

    Dear Zbor

    thanks for perfect solutions.

    thilag

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How2 find number in range and return that number or if doesn't exist then the next highest
    By Crawfinator1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-06-2014, 08:52 AM
  2. Replies: 5
    Last Post: 02-13-2014, 05:37 PM
  3. [SOLVED] Find match, find related cell and return that number
    By HelpHelpHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2012, 06:46 AM
  4. [SOLVED] To find any 4 digit number and return the same number with desired formating effect.
    By neo4u44 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2012, 12:45 AM
  5. Replies: 7
    Last Post: 12-18-2008, 07:34 PM

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