How to give a value to a range of data?

P

pemt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to give a range with values? 2
How to give values to a range? 0
How to give values to a range? 4
How to give a range with values? 1
How to use queries to find a series of range files in another rang 10
Macro to copy data X number of times into a column 0
query that sum two tables 5
Calculate score from Scale 5

Top