+ Reply to Thread
Results 1 to 4 of 4

unique and ordered list from data obtained with formula

  1. #1
    Registered User
    Join Date
    11-22-2018
    Location
    Roma,Italia
    MS-Off Ver
    2013
    Posts
    40

    unique and ordered list from data obtained with formula

    Goodmorning everyone
    in the attached file I have a table in column A the data entered manually and in column B the same data but obtained with a formula
    The goal is to extract the unique and ordered list of data
    now with the formula I use I get the correct result only from the data entered manually (column A) while if I have to apply it to the data of column B (obtained with formula) it returns the first empty field ...
    How to modify the formula in question so that the same result is obtained?
    Thanks for your attention


    Formula :

    =IFERROR(INDEX([Origine],MATCH(0,INDEX(COUNTIF([Origine],"<"&[Origine])/([Origine]>"")-SUMPRODUCT(COUNTIF($D$1:$D1,[Origine])),),0)),"")
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: unique and ordered list from data obtained with formula

    Please try at C2:D2

    =IFERROR(INDEX([Orig.],MATCH(0,INDEX(COUNTIF([Orig.],"<"&[Orig.])-COUNTBLANK([Orig.])+SUMPRODUCT(--ISBLANK([Orig.]))-SUMPRODUCT(COUNTIFS([Orig.],C$1:C1)),),)),"")

    or E2
    =IFERROR(INDEX([Origine],MATCH(0,INDEX(COUNTIF([Origine],"<"&[Origine])-COUNTBLANK([Origine])-SUMPRODUCT(COUNTIFS([Origine],D$1:D1)),),)),"")
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-22-2018
    Location
    Roma,Italia
    MS-Off Ver
    2013
    Posts
    40

    Re: unique and ordered list from data obtained with formula

    Thank you so much
    of the support

  4. #4
    Registered User
    Join Date
    11-23-2020
    Location
    Rome
    MS-Off Ver
    2016
    Posts
    1

    Re: unique and ordered list from data obtained with formula

    Quote Originally Posted by Bo_Ry View Post
    Please try at C2:D2

    =IFERROR(INDEX([Orig.],MATCH(0,INDEX(COUNTIF([Orig.],"<"&[Orig.])-COUNTBLANK([Orig.])+SUMPRODUCT(--ISBLANK([Orig.]))-SUMPRODUCT(COUNTIFS([Orig.],C$1:C1)),),)),"")

    or E2
    =IFERROR(INDEX([Origine],MATCH(0,INDEX(COUNTIF([Origine],"<"&[Origine])-COUNTBLANK([Origine])-SUMPRODUCT(COUNTIFS([Origine],D$1:D1)),),)),"")
    Hi+
    thx so much for the support
    The formula in column "D" does exactly what is espected
    Unforntunately, formula in column "C" does not work when the first cell of the "Orig." is empty. If you try this in the file you attached you can see the result

    Thx

+ 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. Drop down selection results in list +data of ordered styles
    By Scizzy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2020, 12:08 PM
  2. Replies: 8
    Last Post: 06-13-2017, 08:32 AM
  3. [SOLVED] Finding a value based on a drop down list value obtained by an =INDIRECT formula
    By Udaman in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-09-2016, 04:59 PM
  4. Counting Unique Values and Generating an Ordered List
    By amerain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2013, 08:08 PM
  5. [SOLVED] Formula to create an ordered list and remove duplicates without using macros
    By Skiingbeancounter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2012, 06:52 PM
  6. Replies: 2
    Last Post: 03-07-2012, 03:16 PM
  7. freezing data in a cell which was obtained using a formula
    By Joe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2006, 05:10 PM

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