Assigning Values

[bala06]

Dear Excel Users

I would like to assign values from 0 to 2500 as "zero" except some numbers in between them.

Is it possible in using excel.

For example, my data looks like this
starts from 0 and ends in 2500. I want to assign 303, 314, 327 as value "1" and others as "0".

I have attached the copy of data for you reference.

Kindly advice.

Many Thanks

Balaji​

 

[taigovinda]

If your numbers are in A1:A2500, you could use this formula in row 1 a different column (B1 for instance) and then copy down:

=--OR(A1={303,314,327})

It will give 1 for the selected numbers, zero for everything else. If you want to overwrite your original data, you can copy the column of formulas, then paste special -> values over the old values (0 thru 2500).

 

[bala06]

If your numbers are in A1:A2500, you could use this formula in row 1 a different column (B1 for instance) and then copy down:

=--OR(A1={303,314,327})

It will give 1 for the selected numbers, zero for everything else. If you want to overwrite your original data, you can copy the column of formulas, then paste special -> values over the old values (0 thru 2500).

Dear Excel User

It works

Many Thanks
Balaji