+ Reply to Thread
Results 1 to 7 of 7

Large formula, names to match numbers

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Large formula, names to match numbers

    EDITED!!

    AND to make formula say if value is zero display results (both name and a number) as BLANK

    ------


    Hi guys, can I please ask for a suggested formula to help solve values and names next to them as per file and screenshot? My challenge is that if we have same number appearing (like 1 and 1) my formula would bring up matching name twice instead of 2 different names for same number result. What'sa workaround please? Thanking in advance.

    https://www.excelforum.com/attachmen...1&d=1559835964 [EXCEL]

    2019-06-06_1841.png
    Attached Files Attached Files
    Last edited by vill; 06-06-2019 at 11:57 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Large formula, names to match numbers

    In B11
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and in C11
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Large formula, names to match numbers

    Hi Vill,

    Another method that needs no formulas, would be to create a Pivot Table and sort by the number. See the attached.

    Pivot Sort by Value.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Large formula, names to match numbers

    Thanks MarvinP, but pivot table is not an option.

    @Fluff13, your formula works, thanks a lot! Only that it does not bring up BLANK where results are zero, as per edited post description... sorry if edited too late!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Large formula, names to match numbers

    In that case try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Large formula, names to match numbers

    Genius, thank you so much!!!!

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Large formula, names to match numbers

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match multiple names showing row numbers
    By xfiels in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 05-23-2018, 02:02 AM
  2. [SOLVED] How can I match Names to Numbers?
    By tommade in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-19-2016, 02:31 AM
  3. Replies: 13
    Last Post: 06-04-2015, 01:59 AM
  4. Finding and Retrieving Numbers and Names from a Large Workbook
    By disfunctional in forum Excel General
    Replies: 4
    Last Post: 01-02-2015, 04:52 PM
  5. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  6. Index, Match, Large Function returning duplicate names
    By RNeel55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2013, 04:09 PM
  7. Match numbers to names and extract totals
    By c7borg in forum Excel General
    Replies: 4
    Last Post: 01-19-2010, 12:15 PM

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