Count unique numbers in a spreadsheet

Hi there

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!

1 Attachment(s)

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!!!!

Cheers

AlainAttachment 38072