Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to give a value to a range of data? | Excel Discussion (Misc queries) | |||
v-Lookup between values and give result -Help | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
how give excel cell red color if value above range? | Excel Discussion (Misc queries) | |||
Is there any way to give an dynamic name for a range? | Excel Discussion (Misc queries) |