Comparing Values, taking the lowest

[wikid]

Hi guys,

I'm wondering if there is a simple way to compare 2 data items (say weight and width) and choosing just the lowest of the 2, but putting it into a separator, for example:

item        weight       width

box1         10lbs         20cm
box2          12lbs        10cm

etc

I would want box 1's width value, but box 2's weight, then put into a category like:

segments         total # of items
between 1-5                  1
between 6-10                5
between 11-20              11

so basically I was looking for a way to go through and compare 2 values of something and take the lowest value, and then use that in a cumulative value afterwards... if that makes sense...

I was trying something with case statements, but it doesn't seem to be working in my favor so hopefully someone can help me out,

Thanks!