+ Reply to Thread
Results 1 to 4 of 4

A formula to find Customer based on rank

  1. 10-13-2016, 10:31 AM #1
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    A formula to find Customer based on rank

    I need a formula to link Customer name with rank position. Sample file attached.
    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-13-2016, 10:37 AM #2
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,913

    Re: A formula to find Customer based on rank

    Try this ...

    =INDEX(A:A,SMALL(IF($B$2:$B$21=E2,ROW($B$2:$B$21),""),COUNTIF($E$2:E2,E2)))

    Enter with Ctrl+Shift+Enter.
    Reply With QuoteRegister To Reply
  3. 10-13-2016, 11:24 AM #3
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: A formula to find Customer based on rank

    Thank you - works perfectly!
    Reply With QuoteRegister To Reply
  4. 10-13-2016, 07:22 PM #4
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,913

    Re: A formula to find Customer based on rank

    You are welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Formula that can check for two criteria per customer when multiple customer lines exist
    By Macey351 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-05-2016, 10:11 AM
  2. [SOLVED] Find out rank by formula
    By kent97 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-27-2016, 06:16 AM
  3. How to Rank duplicate items with same rank based on its corresponding sum total
    By BIJUJB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-27-2015, 08:50 AM
  4. formula for choose the customer in drop down menu the customer address was auto genrate
    By rana19 in forum Excel General
    Replies: 4
    Last Post: 11-28-2014, 07:53 AM
  5. using pan number of the customer find details of an customer using excel macros
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2014, 03:31 PM
  6. find rank formula
    By debdulal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2013, 02:41 PM
  7. Rank items, select one start date, have remaining dates follow based on rank
    By rob normerica in forum Excel General
    Replies: 1
    Last Post: 08-15-2005, 05:05 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1