Mar 31 2022 01:21 PM
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 about 700 rows, so this should be an all encompassing command for finding all values greater than 0.
Mar 31 2022 01:33 PM
Assuming your 700 values are in cells A1:A700. Then enter in cell B1 formula:
=IF(A1>0,1,0)
and copy this formula down to cell B700.
Then copy range B1:B700 and paste only values.
It's up to you if you want to delete range A1:A700.
Mar 31 2022 01:44 PM
As variant
- enter 1 in any empty cell, Ctrl+C
- apply filter to your range
- Number filter -> Greater than 0
- Ctrl+V
- clean filter
Mar 31 2022 01:45 PM
Mar 31 2022 02:17 PM
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
Nov 18 2022 09:52 AM
Nov 18 2022 09:52 AM
Nov 18 2022 12:10 PM
I'm not sure how to do that if values are everywhere in the grid, not only in one column
Nov 19 2022 02:44 PM