View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ccholai ccholai is offline
external usenet poster
 
Posts: 2
Default Change numbering of data

Hi,

I have a set of numbers - say a fixed block that starts

1
3
15
16
18
20
24
etc

and have palms that have their fronds numbered
Palm 1 Palm2
2 5
4 17
15 20
17 22
18 30
20 40


what i am trying to do is following this set of rules below:

for the second list - whatever the first number is - has to be changed
to the fixed list.

ie. first number in the second list for that certain palm will equal
first number in the fixed list.


so in the end :

Palm 1 Palm2
2 -1 5 - 1
4 -3 17 - 3
15 -16 20 -16
17 -18 22 - 18
18 - 20 30 - 20
20 - 24 40 - 24

it looks easy.... enough

so min(palm1) = min(fixed)
next palm1
next fixed

??