Results 1 to 7 of 7

Finding only distinct rows

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Finding only distinct rows

    Hi,

    There is a data, which contains number of rows which are reapeted more than once.

    The solution is to eliminate the repetion and find only the distinct rows.

    For example:

    A1   B1   C1
    12   14   35
    14   35   12
    6    18   27
    32   19   18
    32   19   18
    16   17   14
    5    1    4
    5    1    4
    1    5    4
    22   14   11

    In the above data "12,14,35" "32,19,18" "5,1,4" has repeated more than once, so the task is to exclude their duplicates and only display their,
    single occurance along with other distinct rows.

    After sorting the above data, it should should look like this:

    D1   E1   F1
    12   14   35
    6    18   27
    32   19   18
    16   17   14
    5    1    4
    22   14   11
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding unique distinct values
    By mrichard in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2016, 11:07 AM
  2. [SOLVED] Finding distinct values across multiple columns - FREQUENCY array?
    By brokenbiscuits in forum Excel General
    Replies: 4
    Last Post: 01-12-2015, 09:06 AM
  3. Finding distinct values within a single string
    By balki42 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2013, 06:39 AM
  4. Replies: 4
    Last Post: 09-13-2012, 07:49 AM
  5. Replies: 5
    Last Post: 07-19-2010, 01:50 PM
  6. Replies: 8
    Last Post: 07-15-2006, 03:10 PM
  7. Sum Distinct Rows in PivotTable
    By Jay in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-18-2006, 11:10 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