Forum Discussion
NEED HELP: How To Select All Values Greater than 0 with Find and Replace
I am having trouble using the find and replace tool. I am trying to select all values greater than 0 and replace them all with 1 to create a binary in a single column. I am working with a dataset of ...
I am trying to do this with the find and replace tool. I know that this is possible because I have done it before but cannot remember the command that I need to type into the find bar to select all values greater than 0.
Are sure that was for Ctrl+H (Find & Replace), not for Filter?
I guess here Using Excel Find and Replace in the most efficient way - Ablebits.com are all possible options
- Can you use filter to find and replace as well?
I'm not sure how to do that if values are everywhere in the grid, not only in one column
- How do you do this in one column, where you change multiple values at the same time, so you have a series of different values in the column, and depending upon the value, there are different replacements? does that make sense?
