How to give values to a range?
Dear,
there are two files. Both are range files. RangeFile1: ITEM RangeStart1 RangeEnd1 ITEM1 1 100 ITEM2 20 200 ITEM3 2 12 RangeFile2: ITEM RangeStart2 RangeEnd2 ITEM1 10 20 ITEM1 50 66 ITEM1 88 92 ITEM2 10 30 ITEM3 4 8 ITEM3 10 18 Results: Range 1 2 3 4 5 6 7 8 9 10 11 12 ...20 21... 50 51...66 67...87 88...91 92 93....100 ITEM1 0 0 0 0 0 0 0 0 0 1 1 1 ... 1 0 ... 1 1... 1 0 ... 0 1... 1 1 0 .... 0 Range 20 21 22 ... 29 30 31 32 ... 200 ITEM2 1 1 1 ... 1 1 0 0 ... 0 Range 2 3 4 5 6 7 8 9 10 11 12 ITEM3 0 0 1 1 1 1 1 0 1 1 1 As you can see, every number from each item range in RangeFile1 will be given a number of "1" or "0" based on RangeFile2. how to do it? Wish your great help again. Thanks, pemt |
All times are GMT +1. The time now is 09:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com