Results 1 to 11 of 11

duplicate ids but the formula should find the greatest

Threaded View

  1. 01-12-2018, 12:25 AM #1
    spr2017
    spr2017 is offline
    Registered User
    Join Date
    11-21-2017
    Location
    SYDNEY
    MS-Off Ver
    2016
    Posts
    35

    duplicate ids but the formula should find the greatest

    Hello,
    i need a formula that can count the number of duplicates and look of the highest value against the duplicate and lookup another data.

    Please see attached for details. thanks heaps.
    Attached Files Attached Files
    Last edited by spr2017; 01-15-2018 at 12:04 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search list find two greatest values
    By quickheart in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2013, 07:16 AM
  2. [SOLVED] find whichever product is greatest
    By TxStarr29 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-28-2012, 02:04 AM
  3. [SOLVED] Excel 2007 : Multiple Occurrences, lookup to find greatest value
    By coxb in forum Excel General
    Replies: 6
    Last Post: 05-12-2012, 11:40 AM
  4. Find greatest multiple of 50 which is less than X
    By psuce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2011, 03:41 PM
  5. Find Greatest Date in a Column
    By Madball in forum Excel General
    Replies: 3
    Last Post: 12-22-2008, 09:18 AM
  6. HOW TO FIND THE GREATEST COMMON FACTOR
    By Hussein Alhasanat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2006, 09:10 PM
  7. in excel conditional formatting find the greatest value in 4rows
    By prac g in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2005, 03:10 AM
  8. find the greatest value among repeated rows in a sheet
    By shijy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2005, 02:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1