View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default table of # of rows with unique combos of values in 4 separated

.. though Excel is having to chug for quite some time!
... and I just don't seem to grasp pivot tables!


Failed to mention in my response earlier that the pivot option
gets you there in a matter of seconds

Perhaps a sample file to illustrate:
http://www.freefilehosting.net/download/3i3il
Unique combos via pivot.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---