Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to give a value to a range of data?
Dear all,
I have a series of data only with range and each item has several ranges. I want to give "1" as values to all spots within all ranges and the rest as "0". Each item has 100 spots from 1-100. For example, Name Range1 Range2 Range3 ITEM1 10-20 30-55 60-80 ITEM2 35-45 72-88 ITEM3 8-15 ..... for ITEM1: 1-9, 21-29, 56-59 and 80-100 will be "0", the rest will be "1". ITEM2: 1-34, 46-71, 89-100 will be "0", and the rest will be "1", ITEM3: 1-7 and 16-100 will be "0", and the rest will be "1". How to do it? Thanks a lot! pemt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
Is there any way to give an dynamic name for a range? | Excel Discussion (Misc queries) | |||
Trying to create formula to give range of stan.deviations of mean | Excel Discussion (Misc queries) |