How to delete a specific cell values in specific rows
I have a specific row, "total respondents", that repeats over and over throughout this sheet. I need to be able to search each individual cell in each row and delete all cell values that are 5 or less (in some cases, there is a "<5", others there is a 1 or 2).
I would do a simple ctrl + f and replace but there could be situations where it would affect the mean and median in other sections of the worksheet.
I attached a screen shot so you can see what i'm looking at. It literally repeats like this throughout the sheet for about 4000 rows.