unique values

OS: Mac OSX 10.5.8 Excel: Microsoft Excel 2008 for Mac, v12.2.6 I'm creating a series of spreadsheets to monitor the traffic on my online store. Due to the technology I'm using, I have the advantage to see the names of my visitors, which allows me to track repeat customers. I have spreadsheets...

Is there a way to count the unique dates (or values) in the pivot table data? I can think of a couple workarounds to solve the problem but not without the limitations.

I have a worksheet that currently has over 25,000 rows (it should double in the next year or two) and 70 columns. I need to compare the results in 60 of the columns and find the unique answers. Using conditional formatting to hilight the unique values is not sufficient for my needs. I...

Hello, I need to count uniques text values in a column that contains names. But I only need to count the unique values that are satisfying a condition in another column. Example: <TABLE style="WIDTH: 166pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=222...

I have the following table: <TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=128 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT...

Is it possible to count the number of unique values in a list that is filtered without using a helpcolumn? I guess I need to use the subtotals in some way.

I have a spreadsheet with content IDs in the first column. I want to analyze the rows with duplicate (not unique) content IDs. The other columns are not the same so the rows are not exact duplicates. I need a formula or macro that will hide or delete the rows with unique, non-duplicate...

A little backwards but I have a parts list with duplicate part numbers in column a and other misc. info in other columns. What I want to do is delete the rows that have a unique part number in column a but retain those part number rows that have duplicate part numbers. There might be 2-4...

I'm having a bit of trouble getting a macro to run. I have a sheet with personnel No's UserID's and Email address as below: <TABLE style="WIDTH: 488pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=650 border=0 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset...