Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula in combination with pivot table | Excel Worksheet Functions | |||
Sort combination of letters and numbers | New Users to Excel | |||
How do I sort different combination of a 4 digits number | Excel Discussion (Misc queries) | |||
Saving Sort Criteria (or Sort Lists) | Excel Worksheet Functions | |||
Table Combination with Sorting | Excel Discussion (Misc queries) |