Results 1 to 8 of 8

Help find MAX value in one column when numeric & alph-numeric values are present

Threaded View

KevinAB Help find MAX value in one... 05-01-2013, 10:42 AM
bebo021999 Re: Help find MAX value in... 05-01-2013, 10:47 AM
KevinAB Re: Help find MAX value in... 05-01-2013, 10:56 AM
bebo021999 Re: Help find MAX value in... 05-01-2013, 11:01 AM
KevinAB Re: Help find MAX value in... 05-01-2013, 11:05 AM
bebo021999 Re: Help find MAX value in... 05-01-2013, 11:18 AM
KevinAB Re: Help find MAX value in... 05-01-2013, 11:22 AM
bebo021999 Re: Help find MAX value in... 05-01-2013, 11:29 AM
  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Help find MAX value in one column when numeric & alph-numeric values are present

    Below is a sample of the values below. Notice that 3 entries begin with "RD". How can I find the MAX value that begins with "RD". The RD-values will always end with 4 digits.

    The formula needs to work even if the column is sorted in different ways. Thanks for your time.

    20586
    RD0001
    20588
    20589
    20590
    20591
    20592
    20593
    20594
    20595
    RD0002
    20597
    20598
    20599
    20600
    RD0003
    20602
    20603
    20604
    Last edited by KevinAB; 05-01-2013 at 10:44 AM. Reason: added 2nd line

Thread Information

Users Browsing this Thread

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

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