To answer the original question. OOo calc does not support that functionality (ie, display number of records that were returned in the filter).
You can of course raise an enhancement request which may be included in later releases of OOo... /paul On 2/3/06, David Chapman <[EMAIL PROTECTED]> wrote: > Counting unique entries in a range... > > http://www.openofficetips.com/blog/archives/2005/08/counting_unique.html > > On 2/2/06, Michael <[EMAIL PROTECTED]> wrote: > > > > Welsh-Huggins, Andrew wrote: > > > I need some help related to OpenOfficeCalc. > > > > > > On Excel, if I autofilter and then select a category, (say, the number > > > of $10,000 donations in a column of contributions), Excel will tell me > > > how many of that particular number in the lower left hand corner > > > automatically. (e.g., "72 of 3,000 records found.") > > > > > > OpenOfficeCalc won't do that for me; does anyone know if it can, and if > > > so, how to activate it? > > > > > > Thanks. > > > > > > Andrew Welsh-Huggins > > > > I have a similar situation. I have a sheet full of addresses, sorted > > by postal code. I would like to know 1) the number of unique postal > > codes and 2) the number of records in each postal code. Does Calc > > have functions to do this? > > > > Cheers > > M > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > -- > My OpenOffice Calc Website > http://www.openofficetips.com > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]