+ Reply to Thread
Results 1 to 3 of 3

formula for duplicate values

  1. #1
    Forum Contributor
    Join Date
    09-21-2012
    Location
    greece,athens
    MS-Off Ver
    Excel professional plus 2016
    Posts
    157

    formula for duplicate values

    Hallo and happy new year to all of you.
    Please take a look at the attachment.
    Thank you all.
    Attached Files Attached Files
    Power! is knowledge...............

  2. #2
    Registered User
    Join Date
    09-01-2011
    Location
    georgia
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: formula for duplicate values

    I may not be the most well versed in elegant ways to find, order and show duplicate values but the attached solution does work as I believe you intend.

    My data is on page 2. I used a table to check if a value was a duplicate. Then I created a table to show what numerical rank that value has in ascending order. Finally, I used the index function to pull the first ranked value then the second and so on for the table with the border around it.

    douplicate_values.xlsx

  3. #3
    Forum Contributor
    Join Date
    09-21-2012
    Location
    greece,athens
    MS-Off Ver
    Excel professional plus 2016
    Posts
    157

    Re: formula for duplicate values

    That was good ,very good my dear persecuted.
    It will help me to understand how those formulas works who know in a future task of mine.
    THANK YOU A LOT...

+ 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] Formula for duplicate values
    By lukesmith7 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2014, 04:21 AM
  2. [SOLVED] Formula to duplicate row values
    By mattmc419 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2014, 09:20 PM
  3. Formula to Exclude Duplicate Values
    By jjcgirl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 11:43 AM
  4. [SOLVED] Large Formula with Duplicate Values
    By triv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 02:19 PM
  5. Formula for Duplicate Values
    By anitaselvarajan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-27-2012, 03:56 AM

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