+ Reply to Thread
Results 1 to 1 of 1

Get distinct values from multiple non contiguous columns and place them in columns

Hybrid View

  1. #1
    Registered User
    Join Date
    05-23-2008
    Posts
    8

    Get distinct values from multiple non contiguous columns and place them in columns

    I have a worksheet with about 25 columns. Every other column up to column N has a list of values 9 rows deep.

    I want to get the distinct values from those first non contiguous columns and put them into the last three columns.

    Formula: copy to clipboard
    =IFERROR(IFERROR(INDEX($B$3:$B$11,MATCH(0,COUNTIF($R$2:R2,$B$3:B11&""),0)),IFERROR(INDEX($E$3:$E$11,MATCH(0,COUNTIF($R$2:R2,$E$3:$E$11&""),0)),IFERROR(INDEX($H$3:$H$11,MATCH(0,COUNTIF($R$2:R2,$H$3:H11&""),0)),IFERROR(INDEX($K$3:$K$11,MATCH(0,COUNTIF($R$2:R2,$K$3:$K$11&""),0)),INDEX($N$3:$N$11,MATCH(0,COUNTIF($R$2:R2,$N$3:$N$11&""),0)))))),"")


    I have this so far. Problem lies when switching to the next column of those last three.

    Any help?
    Attached Files Attached Files

+ Reply to Thread

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