View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gimme_donuts[_2_] gimme_donuts[_2_] is offline
external usenet poster
 
Posts: 8
Default Table row criteria combination sort out

Hello all,

I don't know if there is an easy way to do what I'm gonna explain. But I
really need this, because if I dont find an automated way its gonna take ages
:(


Lets put it like this:


Table config
----------------------------------------------------------------------------
It's a double entry table

X axis are the criteria of houses (ex: 1 bedroom, 2 toilets, basment, etc
in total there are 52 criteria)

Y axis are the houses name (in total there are more than 200)


So if for example HOUSE X has one bedroom , there will be a YES under the "1
bedroom" criteria, and so on for the 52 criterias

----------------------------------------------------------------------------
----------------------------------------------------------------------------


What need to be done:
----------------------------------------------------------------------------
I need to know which are the most common combinations of criterias for all
the inputted Houses.

For example 40 houses have : 1 bedroom, 1 toilet, 2 fridges and a kitchen


That's it actually.


I guess I would have to predefine which combination of criteria the programm
has to check as it would involve some IA otherwise....
----------------------------------------------------------------------------
----------------------------------------------------------------------------

Maybe there is allready a template somewhere but I coudn't find...

All help is welcome and I thank you a lot!!!!