I am trying to create a list of unique values from an entire column in another sheet. To do so I am using the following function:
=IFERROR(INDEX(Export!$M$2:$M$60000, MATCH(0, IF(ISBLANK(Export!$M$2:$M$60000), 1, COUNTIF($A$1:A1, Export!$M$2:$M$60000)), 0)), "")
When activated, however, the function returns the first value over and over. I'm not sure what I am doing incorrectly - although I'm sure it is something fairly basic and obvious - and would appreciate any assistance anyone might be able to offer!
Thanks in advance,