Hi,
I have this formula:
Which returns unique values. Is there any way to sort this list alphabetically within the formula?![]()
=IFERROR(INDEX('CJ13'!$J$6:$J$278,MATCH(0,INDEX(COUNTIF(Summary!$AD$57:AD57,'CJ13'!$J$6:$J$278),0,0),0)),0)
Hi,
I have this formula:
Which returns unique values. Is there any way to sort this list alphabetically within the formula?![]()
=IFERROR(INDEX('CJ13'!$J$6:$J$278,MATCH(0,INDEX(COUNTIF(Summary!$AD$57:AD57,'CJ13'!$J$6:$J$278),0,0),0)),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks