Sorting by multiple TRUE entries, a challenge for Excel experts!

[alanbarry]

Hi all,

I have a sheet as follows;

	1800	18001	18002	18003
1234	TRUE		TRUE
1235	TRUE	TRUE	TRUE
1236
1237		TRUE	TRUE

<tbody>
</tbody>

What I need to do is sort this so that;

All 1800 TRUE cells are grouped together
All 1800 + 18001 TRUE cells are grouped together
All 1800 + 18001 + 18002 TRUE cells are grouped together
etc etc

to give me a table like this;

	1800	1800 + 18001	1800+18001+18002	18001+18002
1234	TRUE
1235	TRUE
1235		TRUE
1235			TRUE
1237				TRUE

<tbody>
</tbody>

For all possible combinations! This will allow me to quickly look and see which codes (eg. 1800, 18001) are grouped together by a TRUE classification.

It is complicated, because as you can see, the 1235 designation will appear across three of these categories (1800, 1800+18001, 1800+18001+18002).

I would be really grateful if someone could help here! If I have explained this badly, please do let me know!

Thanks,
Alan.

 

[alanbarry]

*Bump* I really would appreciate any help on this