Results 1 to 3 of 3

Find highest version number for each material number

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Bagsvaerd, Denmark
    MS-Off Ver
    Office 2010
    Posts
    2

    Find highest version number for each material number

    Hi
    I am working in Excel 2010. I would like a formula that will calculate the highest version number for each material number (see below)

    Data layout as attached DataMat.xlsx
    Ver Material# Answer
    62 7234783 64
    63 7234783 64
    64 7234783 64
    50 7243303 52
    51 7243303 52
    52 7243303 52
    50 7252552 53
    51 7252552 53
    52 7252552 53
    53 7252552 53

    For each material number (column B) I need to derive the highest version (column A) - So the fomular should return the value shown in the "answer" column

    Ideas are welcome.

    /Keld
    Attached Images Attached Images

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: 1
    Last Post: 06-10-2013, 07:08 PM
  3. Find highest revision number in one column of a item number in another column
    By Tasiast in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2013, 01:03 PM
  4. Find highest number of sales in a date range and show seller and sale number
    By audiofreak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2012, 03:34 AM
  5. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 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