Thanks a lot for help
I didn't expect all these possibilities ..
Can I pick the nearest to 21.6 *2 which will be
43 , 107 , 35 ...
Or the first value would be half of the second value such as this possibility 49 , 99 , 37 (as 49 * 2 =98 and 98 is the nearest to 99)
I just need one possibility and I need to do the task using VBA
Thanks advanced for help
Bookmarks