Using MATCH and INDEX to extract unique values

Some time ago, someone on this list posted a array function using MATCH
and INDEX to extract unique values.

I used the formula to great effect, but now I can't find the
spreadsheet I used it in, and I need to recreate the formula.

I also haven't been able to turn it up using google search.

Can anyone here point me to the correct formula again?

Thanks.

You can download an example here, it's the third formula

http://nwexcelsolutions.com/Download...ue_records.xls


Regards,

Peo Sjoblom




"jg70124" wrote:

> Some time ago, someone on this list posted a array function using MATCH
> and INDEX to extract unique values.
>
> I used the formula to great effect, but now I can't find the
> spreadsheet I used it in, and I need to recreate the formula.
>
> I also haven't been able to turn it up using google search.
>
> Can anyone here point me to the correct formula again?
>
> Thanks.
>
>