demarc
12-20-2012, 05:59 AM
Hi all,
I am trying to sort some data in this format:
20
30
40
41.7
50
60
70
and I need function that will pull out from 30 - 41.7 and then 41.7-70. Note that the first number needed is not the 20 but the 30 and the last number needed is the last number in the column.
I need to identify what row the odd number out is in (I am doing this using Mod(A1,10)<>0) and then pull out all numbers in the column from that row back up to the 30. Then in a separate list I need from 41.7 until the end of the column of numbers, i.e.
30
40
41.7
and
41.7
50
60
70
Thanks in advance for your help.
Demarc
I am trying to sort some data in this format:
20
30
40
41.7
50
60
70
and I need function that will pull out from 30 - 41.7 and then 41.7-70. Note that the first number needed is not the 20 but the 30 and the last number needed is the last number in the column.
I need to identify what row the odd number out is in (I am doing this using Mod(A1,10)<>0) and then pull out all numbers in the column from that row back up to the 30. Then in a separate list I need from 41.7 until the end of the column of numbers, i.e.
30
40
41.7
and
41.7
50
60
70
Thanks in advance for your help.
Demarc