Results 1 to 4 of 4

Distinct values

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    America
    MS-Off Ver
    Excel 2003
    Posts
    5

    Thumbs up Distinct values

    Am trying to list distinct values in a column from a column of another sheet.
    ColA Col B
    A 3
    B 4
    B 4
    C 5
    A 3
    C 5
    B 4

    Always A, b and C are having same values for Col B

    am trying to get the below output:

    A 3
    B 4
    C 5

    I used If and COuntif, but not possible. Can somebody help me
    Last edited by kushibobby; 02-23-2012 at 07:58 AM.

Thread Information

Users Browsing this Thread

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

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