Results 1 to 3 of 3

Unique List - Sort with Text and Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    18

    Unique List - Sort with Text and Numbers

    I have a formula that extracts a unique distinct list from a column of data. It only seems to work with text or numbers, but not both. I have been trying to get it to work with numbers to no avail.
    I would like to ideally be able to use an if function that would convert the numbers into text in memory, instead of creating a separate countif number formula for each countif in the formula.

    =INDEX(List,MATCH(MIN(IF(COUNTIF($B$2:B2,List)=0,1,MAX((COUNTIF(List,"<"&List)+1)*2))*(COUNTIF(List,"<"&List)+1)),COUNTIF(List,"<"&List)+1,0))

    I have tried if(isnumber(list),text(list,"0" before the first countif.
    I hope someone can help.
    Attached Files Attached Files

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