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.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.