# Count the number of unigue numbers based on number in another column.

1. ## Count the number of unigue numbers based on number in another column.

I need to count the number of unique numbers in column C and display the number of unique numbers that occur in column C for each unit number in column F.
Match the number of unique numbers to each unit number in column L to build data table. A pivot table will not work for the overall project.

Thanks to all.

Excel QuestionII.xlsx  Register To Reply

2. ## Re: Count the number of unigue numbers based on number in another column.

see if this ARRAY formula helps in cell M2, drag-filled down: ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: Count the number of unigue numbers based on number in another column.

Here's another one...

Array entered** in M2 and copied down as needed:

=SUM(IF(FREQUENCY(IF(F\$2:F\$720=L2,C\$2:C\$720),C\$2:C\$720),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.  Register To Reply

4. ## Re: Count the number of unigue numbers based on number in another column.

Thank you very much. I thought I had tried this formula earlier but I obviously had an error along the way.  Register To Reply

5. ## Re: Count the number of unigue numbers based on number in another column.

Thank you.

I can not agree more with your KISS motto. This is great.  Register To Reply

6. ## Re: Count the number of unigue numbers based on number in another column.

You're welcome. Thanks for the feedback!   Register To Reply