I'm trying to figure out how to get an excel document containing product dimensions (width x height) to recognize that, for example, 10x20 is the same as 20x10. Ideally I would just like to add another column to the sheet that puts all dimensions with the lowest value first, rather than the width first and then the height. This way I can sort by dimensions, or use a pivot table to count the exact number of products in each dimension.
The columns I have right now are:
A = width
B = height
C = w x h (using the formula A1&" x "&B1)
How can I get column C to compare A&B and return the lower value x the higher value?
Bookmarks