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
