Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

??

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change numbering of data ccholai Excel Programming 2 June 4th 09 09:31 AM
change page numbering 1st & last MLS at LPC Excel Discussion (Misc queries) 2 September 15th 07 01:42 AM
Change page numbering E Stein Excel Discussion (Misc queries) 2 July 2nd 07 08:42 PM
Numbering data pairs Art Charts and Charting in Excel 1 November 15th 05 02:58 PM
How do i change the numbering shceme of my rows? row number renamer Excel Worksheet Functions 1 November 5th 04 04:28 PM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"