• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Challenge 007 - return distinct/duplicate /unique values as an array

Somendra Misra

Excel Ninja
@Asfandyar Ali

With the type of data layout in output, ii is difficult to create formula which can grow when you drag them. Suggest yo to go with VBA.

And also so many formula over 100 pages will slow down your workbook.

Regards,
 

siva97237

New Member
use
=IFERROR(SMALL(IF(INDEX(FREQUENCY(data,data),0)>0,(data)),ROWS($1:1)),"") for Unique Values
=IFERROR(SMALL(IF(INDEX(FREQUENCY(data,data),0)=1,(data)),ROWS($1:1)),"") for Distinct values and
=IFERROR(SMALL(IF(INDEX(FREQUENCY(data,data),0)>1,(data)),ROWS($1:1)),"") for Duplicates
 
Top