Hi
I wanted to share this with our Lounge Users. (I used this method in recent post regarding emailing).
Others might find this useful.
The attached file shows an example of using a custom function to count the number of unique entries in a range.
If the range is part of a filtered range, only the visible cells are used for the counts.
I added a formula to automatically give a ‘visible-record-number’, which adjusts automatically as data is filtered.
You can use an INDEX/MATCH combination with this ‘visible-record-number’ to fetch data from the nth visible record of a filtered list of data.
zeddy
