Quickest way to find/replace based on values?
 

Hello--

I'm trying to find the quickest way to find and replace a range a values.

In one column, I have numberical values 1 through 1225. I need to find the
values ranging from 1 - 44 and replace them with 4 FT, then values, 45 - 88
and replace them with 8 FT. I know I can also enter and then copy the values
down, but I have about 40 groupings and know this will be time consuming.

Is there a quicker way of doing this perhaps by creating a macro of some
sort or using a table that defines the groups I want to assign to the values??

Quickest way to find/replace based on values?
 

The easiest way is to sort the data. I would add a new column and auto
number the rows first so you can get back to the original order. Then sort
on the Feet column and the new numbered column using the sort as the index.
then replace the numbers you wantt changed. They will be in consecutive
rows. the sort again using the numbered column as the index. this should
only take a minute to do.

"Cecilia" wrote:

Hello--

I'm trying to find the quickest way to find and replace a range a values.

In one column, I have numberical values 1 through 1225. I need to find the
values ranging from 1 - 44 and replace them with 4 FT, then values, 45 - 88
and replace them with 8 FT. I know I can also enter and then copy the values
down, but I have about 40 groupings and know this will be time consuming.

Is there a quicker way of doing this perhaps by creating a macro of some
sort or using a table that defines the groups I want to assign to the values??