Modify Unique List Array

Originally Posted by DonkeyOte

I don't understand where you're looking for the value (97.25%) ? Will the value in E1 ALWAYS be listed in "the" range ? If not are the values listed in order ?

A sample would invariably quicken the process in terms of finding a resolution.

The rates are already arranged in ascending order.

The value will always be listed in E1. Which will set the range