Please_H
Board Regular
 Joined
 Apr 16, 2017
 Messages
 181
 Office Version

 2019
 Platform

 Windows
Dear All,
I hope everyone is safe.
I am in a need of having to look at a 'range of Number Values' and get a desired number ranging from 1 to 200 as the range would keep updating up to 200 entries.
Ex :
Data
A1 300
A2 400
A3 500
A4 600
A5 700
A6 1500
A7 200
A8 100
A9 
A10 
Outcome Needed
B1  It looks from A1 to A200 and finds the highest number and returns 200, then returns 199 to the number next to the highest in the Range and goes as far as to return 1 to the lowest number and returns a "0" for the "" ( A9, A10 are "" because the Colomn A returns "" until it picks a value from a different sheet. If same values are found for an example in cell A23 and A56 it gives the higher number to the A23 and a lower number to A56 example : B23 > 79, B56> 78
Thanks a lot.
Stay safe.
I hope everyone is safe.
I am in a need of having to look at a 'range of Number Values' and get a desired number ranging from 1 to 200 as the range would keep updating up to 200 entries.
Ex :
Data
A1 300
A2 400
A3 500
A4 600
A5 700
A6 1500
A7 200
A8 100
A9 
A10 
Outcome Needed
B1  It looks from A1 to A200 and finds the highest number and returns 200, then returns 199 to the number next to the highest in the Range and goes as far as to return 1 to the lowest number and returns a "0" for the "" ( A9, A10 are "" because the Colomn A returns "" until it picks a value from a different sheet. If same values are found for an example in cell A23 and A56 it gives the higher number to the A23 and a lower number to A56 example : B23 > 79, B56> 78
Thanks a lot.
Stay safe.