zraj07
Board Regular
- Joined
- Jun 15, 2006
- Messages
- 80
You have a column of values in A: Say 3, 55, 68, 98, 105, 210, 280, 300, 301, 367
You want to assign a value to each number, using multiples of 100
For instance, 3, 55, 68, and 98 would each get a value of 100 assigned to them in Column B, 105 would get a value of 200 assigned to it, 210, 280, and 300 would get a values of 300, and 301, 367 would get values of 400.
Any suggestions ?
You want to assign a value to each number, using multiples of 100
For instance, 3, 55, 68, and 98 would each get a value of 100 assigned to them in Column B, 105 would get a value of 200 assigned to it, 210, 280, and 300 would get a values of 300, and 301, 367 would get values of 400.
Any suggestions ?