Help using COUNTU

[pedrofogao21]

Hi guys,

In a spreadsheet, I want the cells in column A to return the number of unique occurrences in column C, taking into consideration the number of rows.

I was suggested the formula =TRUNC(IF(LEN(C$2:C3),SUMPRODUCT(1/COUNTIF(C$2:C3,C$2:C3))),0), in cell A2 and forward, and it does work. However, since I often have around 2,000 rows of data, it takes a very long time to calculate this worksheet (around 4 minutes).

Does anyone know how I can do this using the COUNTU function. I realize the calculation would be lighter that way.

I am sorry I don't have the example attached, but I am having a hard time trying to attach a file.

Thanks in advance!

[arlu1201]

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[pedrofogao21]

Sorry, I tried that, but the original window (the one with the post) freezes after the file uploads (it is a very small file and I waited a few minutes)

[arlu1201]

Do you get any error msg while uploading the file?

[pedrofogao21]

There is no error message, but the page simply freezes after I click on Upload File (I waited a few minutes) and it doesn't let me do anything else.

Thanks

[pedrofogao21]

I believe I was finally able to attach the file.

Thanks!