Thread: Cycle between next lowest number

Hi,

I'd like to be able to cycle through a restricted number of values in a matrix, using a form. In addition, I'd like to use a formula to define the first value of that cycle. Eg:

matrix:{5;12,5;21;23;30}

find lowest number higher than 16

should be: 21, 23, 30 <- i want to be able to cycle through these numbers with a form (scroll bar)

if possible, would also like this formula to show not only {21,23,30} but also {5+12,5=17,5;21;23;30}

Is it possible?

Thanks

Hi,

first it is possible
second it is not straightforward

To know how best to answer this it would be helpful to have somebackground information.
- is this a one-off exercise
- where is the data in the table coming from (and how is it entered)
- are the row and column headings always the same values and the same number of them
- How big is the table likely to be
- who is going to use the spreadsheet (just you or other people)
- what does the data relate to

My thoughts are :
- if the data was stored as three columns eg:
col, row, value
0.10,6,3.83

- then you can use ADO sql query to do a select of all values greater than your value.
- and another ADO sql query to do a union self join witha sum as a returned value and again exceeding your value.
- it would be easy to have a table displayed in the same form as your current one

This isn't quite the same as your suggestion But I wondered if this would do the job.

My assumption is that only the sheet "Final" would be used. I left the others in there so you could see my working

The curses of having problematic broadband.

Hopefully this one is attached.