Be warn! I was a mainframe guy! Used to work with EASYTRIVE, thru which I
could manipulate any file and report in a split seconds.

I have a spread-sheet of orders. Within each order there are line items and
each could be a different, say, color or same color. I need to separate the
orders with the same colors into one file and the mixed ones into another.

e.g.
Order Line # color
100 1 245
100 2 245
100 3 245
110 1 245
110 2 290
120 1 200
120 2 200
150 1 050
150 2 300


Need to put all 100 and 120 in one file and 110 and 150 in another file.

Is there an easy way to do this?

Thank you for th help.