| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace number from a range with single value
I have a list of numbers in one column, e.g. 3.1, 3.4, 2.3 4.3 etc. Does
anybody know if I can replace numbers within a range with one value i.e. all numbers between 3.1 and 3.5 to become 3B all numbers between 2.0 and 2.5 to become 2B and numbers between 4.0 and 4.5 to become 4B, the list would then become 3B, 3B, 2B, 4B. Is it possible to do this without going to individual cells, similar to the find and replace function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Challenge: Detection of first and Last +ve number in a range | Excel Worksheet Functions | |||
| Replace variable row number in formulas | Excel Discussion (Misc queries) | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| How to add one number to a range of numbers | Excel Worksheet Functions | |||
Threaded Mode
