Results 1 to 7 of 7

max value in column of alphanumerics, with blanks

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2015
    Location
    bristol, uk
    MS-Off Ver
    2013
    Posts
    3

    max value in column of alphanumerics, with blanks

    Hi. See attached spreadsheet showing extract from a larger sheet.

    I have a column of part numbers with alpha prefixes. The column also has blanks.

    I need a formula that reports the maximum numeric suffix. i.e. 104801.

    The top cell is my current effort, but this doesn't ignore the blanks so returns an error.

    Note, the prefix will always be P-COL-.

    Thanks.
    Attached Files Attached Files
    Last edited by TheKraken; 10-26-2015 at 07:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 06-15-2016, 09:53 AM
  2. [SOLVED] Creating Single Column List from multi-row/column table and removing blanks
    By ChemistB in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-10-2014, 02:23 PM
  3. [SOLVED] find a column by date and filter that column by removing blanks
    By rsami in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2013, 10:56 PM
  4. Replies: 1
    Last Post: 08-13-2012, 10:59 AM
  5. Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column B
    By bighandsam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:16 PM
  6. [SOLVED] Returning most recent daily data in a column if blanks in column
    By InnesMcc in forum Excel General
    Replies: 6
    Last Post: 11-04-2011, 09:41 AM
  7. [SOLVED] Returning most recent daily data in a column if blanks in column
    By InnesMcc in forum Excel General
    Replies: 2
    Last Post: 11-04-2011, 06:28 AM

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