Hello,
Looking for some help, I have large set of numbers and Im trying to pull information from to create a help / crib sheet.
Column M is the reference number and im looking for a formula for Column J and L to provide the Min and Max Numbers associated Colum M based on the values in Column F and G,
I have manually inserted the min / max values for Column M value 0 to show what im looking for, so 0 is equal to a min value of 0 and a max of 0.5, 1 has a min value of 1.6 and max 2.4
Any help gratefully appreciated as im struggling to come up with something
Looking for some help, I have large set of numbers and Im trying to pull information from to create a help / crib sheet.
Column M is the reference number and im looking for a formula for Column J and L to provide the Min and Max Numbers associated Colum M based on the values in Column F and G,
I have manually inserted the min / max values for Column M value 0 to show what im looking for, so 0 is equal to a min value of 0 and a max of 0.5, 1 has a min value of 1.6 and max 2.4
Any help gratefully appreciated as im struggling to come up with something