Results 1 to 3 of 3

Thread: Formula To Search The Last Occurance Of A Number Series

  1. 10-24-2013, 07:09 PM #1
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Formula To Search The Last Occurance Of A Number Series

    Looking for the last number to begin (* 1) (* 2)
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 10-24-2013, 07:33 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    Couple of wys..

    =LOOKUP(2,1/(LEFT(C4:C16,2)="1*"),C4:C16)

    =LOOKUP(9.999E+307,FIND("1*",C4:C16),C4:C16)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 10-25-2013, 03:03 AM #3
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    very good
    thank you
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Nth Day Of Week Number Using Formula
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 06-16-2013, 06:40 PM
  2. Formula To LookUp For Revised Phone Number Having Variable Length Starting Digits
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-09-2013, 01:47 AM
  3. Repeat A Value In A Predefined Number Of Rows Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-01-2013, 02:22 PM
  4. Nested Search Function Excel Formula
    By trankim in forum Excel Help
    Replies: 6
    Last Post: 10-29-2012, 10:29 PM
  5. Number 9.99999999E+307 in Excel Formula
    By Admin in forum Familiar with Commands and Formulas
    Replies: 0
    Last Post: 06-11-2012, 04:09 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
  •  

Forum Rules