Count unique numbers in a spreadsheet
I have a spreadsheet of documents that have been downloaded in one column, and the e-mail address of the person who downloaded it in another.
Some people have downloaded the same document more than once.
I have been able to calculate how many times each document has been downloaded using the COUNTIFS function, but I am battling to identify how many unique downloads there have been....
There is a function FREQUENCY that I thought would help, but it does not appear to give the right answers - it looks for a range...
Please give me some tips.....
Format for the spreadsheet of data is:
A B C D E
Filename - Document Number - Description - Email - Date/Time
There are 2200 rows.................!!
Thanks for the advice!
Thanks for the suggestions.........
Here is a sample of the data that I want to extract.
The data is in one sheet, whilst the summary is in the other worksheet of the file.
Thanks so much!!!!