Since you are using a filterd list I assume it is AutoFilter. Is this
correct? Have you tried using SUBTOTAL function. Look it up in Help for all
of the various mathematical calcs it can return and automatically updates
each time the filter is changed.

--
Regards,

OssieMac


"Bannor" wrote:

Hi!

I've been battling with this for a while now, I hope you guys can help! :)
I'm using Office 2007 Enterprise on Win XP Pro SP3.

I have a sheet of data comprising store names, product quantities, product
prices, etc. The store names are in the first column (text values,
obviously), with product names, prices, quantities, etc in subsequent
columns. There are at present about 50 columns and 2500 rows of data, with no
blank rows. This data is filtered.

What I need to do is to count the number of unique values in a given column
(for example the number of stores that stock a particular product, with the
list having been filtered by that particular product name). I do not need to
know the frequency or the names of the stores - just how many there are in
the filtered list.

The answer given to this particular question
[https://www.microsoft.com/office/com...en-us&m=1&p=1]
is the closest I have found so far to giving me what I need, but this does
not adjust for when rows are filtered / hidden.

I don't particularly want to use a pivot-table; that would be rather
cumbersome to use easily. I need to use this result in other calculations.
Actually, I'm a bit surprised that a function of this nature has yet to be
built-in to Office 2007.

I hope this doesn't stump you guys like it has me! :)

--
Philip