| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot reports
I have a worksheet that has 3 columns and 24000 rows of data. There are
numerous duplicate records. I need to report how many individuals are using the site and not how many hits (each record is a hit). I want to use a pivot table report. I have been trying for two days to come up with a formula that will give me a result using only unique records. I can do an advanced filter and then subtotal, but I really want to utilize the pivot table reports and charts. BIG feather in my cap if I can pull this off. PLEASE : ) HELP. Any suggestions would be greatly appreciated. Denise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create calculated items on pivot table reports? | Excel Worksheet Functions | |||
| how to print reports from pivot table | Excel Discussion (Misc queries) | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Pivot Reports and < or values | Excel Discussion (Misc queries) | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
Threaded Mode
