Getting Divorced...

[dmoc]

...so we sit down (amicably ) and compile a list of belongings such as...

ITEM OWNER
Bike Him
Car Her
Computer Him
Stereo Her

...and now we want a list such as...

OWNER ITEMS
Her Car,Stereo
Him Bike, Computer

...and after "dis'cussin" how to do this we decide to go to arbitration, ie, this forum

So, any suggestions?

PS: Just joking, no divorce, thought I'd make the request entertaining

[David]

Without actually trying it ...

Have both lists in the same order: Owner, Item.

Now try SORT and FILTER options. It's a matter possibly of just arranging the material as is?

Good luck on the hypothetical divorce. Let us know how you make out. According to common practice, you might as well just make one list, for her. That also makes it easier to sort.

David.

[jrkrideau]

[richhill]

[David]

Or look for an older version. I hear older is better.

David.

[Villeroy]

Make this table a little bit more spicy:
Add a third column VALUE!
Since it may take a while until you agreed about it's content, fill it with ones.
Select this table (or the entire columns)
Data > Data Pilot
In the wizzard drag the ITEM into the left Row-Box, OWNER into the top Column-box and VALUE into the large box in the center.
As target for the data-pilot, choose the top-left cell of some free space on any sheet. After adding some VALUEs, select a cell within the new data-pilot range and apply Data > Refesh.

[BookLady]

What no column for when or how acquired? Who gave what to whom when and why can make a big difference.

This thread reminds me of one on another board about just what things people keep track of using spreadsheets.

And David, if they spend a little more time "making out" instead of "making lists" the divorce issue would probably be moot.

[David]

[Villeroy]

[dmoc]

Thanks for all the suggestions! In the mean time I did it by hand (constructing the list that is). There's no values involved and my best guess is a macro to scan and compile... but list handling would be nice (anyone used LotusNotes macros? Good list handling).

BTW: If I ever get divorced (assuming I ever get married) I'll be back for advice

Thanks all and keep the suggestion coming if you come up with any interesting solutions.

[9point9]

You could always try a macro to work it's way through the lot. That would be more useful if your fictional soon-to-be-estranged wife and you had a lot to argue over.