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)),"")
Bookmarks