Hello I want to find a way on how I can update an existing sheet with a lot of data already and I want to update a blank row as seen in this photo (see the last column full of the comments about the weather saying up if its above 19 or down if its below 20)
I keep running the search function to filter and then to update the last column to say if the temp is above or below 19/20, but every time I run it, it just overwrites the cells that were already filled. So if I ran it the first time, it fills cells on the 1,2,3 rows, and when I run it the second time, it will just fill the those same cells in the same row.
Is there a way for me to be able to fill the next cells after the first x amount have already been filled?
Any help will be great.