Greetings,

I'm trying to create a MIN-MAX formula that will retrieve the MIN and MAX values in a range. The trouble I'm having is, the range contains two types of values. Some contain a $, others contain a %. Essentially, I would like to return the MIN and MAX for both types of values so that if my range looked something like

1$
2$
5%
7%
8$
10%

The formula would return something like: 1$-8$, 5%-10%

Any assistance would be greatly appreciated!