OMG Excel Arrays (a UNIQ filter)

Right. I needed to write a UNIQ filter in an excel spreadsheet and this needed to be implemented using functions i.e. not VB for two reasons; I can’t and the customer doesn’t want me to.
I start with

To find this use youtube search with the argument excel magic tricks. We are looking for example 1023. The author, has written a book, which is available from here…
I found the following microsoft references useful.

  1. INDEX function at
  2. ROW function at
  3. MATCH function at
  4. SMALL function at

This video shows a simple way to calculate the number of uniq values in a list.

I have built an example,  Uniq Filter demo in Excel this time.


Image Credit: @flickr CC Zamzara 2006 BY-NC-ND +here…

This site uses Akismet to reduce spam. Learn how your comment data is processed.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.