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
see if this ARRAY formula helps in cell M2, drag-filled down:
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you very much. I thought I had tried this formula earlier but I obviously had an error along the way.
Thank you.
I can not agree more with your KISS motto. This is great.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks