Excel find and replace within a range of values?

  • Thread starter Thread starter Bumble
  • Start date Start date
B

Bumble

I've basically got a data set, that I need to convert to values for a neural
net. My problem is I can replace standard entries such as 'male' to the
corresponding numeric value but for fields such as age, where say a range
between 25 and 35 is 0.5, it has to find every age within that range and
convert them all to 0.5. Is there an easy way of doing this without having
to do it manually?

Si

--
Bumble

"I'm flat out, you're so beautiful to look at when you cry. Freeze don't
move, you've been chosen as an extra in the movie adaptation of the sequel
to your life. Shady Lane, everyone wants one, Shady Lane, everybody needs
one" - Pavement
 
If your data is in a table this sort of thing is dead easy in Excel.
Say your data is in column A. Insert a blank column B & copy th
formula :-
=IF(AND(A1>=25,A1<=35),0.5,A1)

Copy this new column of numbers.
Select the top item in the original column.
Edit/PasteSpecial Values.
Delete column B
 
Back
Top