ExcelBanter - auto select of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - auto select of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/149303-auto-select-numbers.html)

ekkeindoha

auto select of numbers

I would like to know if there is a formula to do the following .
Let's say I put in 22 - 25 - 65 - 98 and I want this to be automaticly
linked to the following numbers 22 - 27 - 70 - 102 . (Please note some
figures are equal to and other are either higher or lower than the figure)

thanks

Toppers

auto select of numbers

What's the relationship between the two sets of data?

"ekkeindoha" wrote:

I would like to know if there is a formula to do the following .
Let's say I put in 22 - 25 - 65 - 98 and I want this to be automaticly
linked to the following numbers 22 - 27 - 70 - 102 . (Please note some
figures are equal to and other are either higher or lower than the figure)

thanks

All times are GMT +1. The time now is 11:54 AM.