I have columns A and B that look like this:

5 80
5 79
5 81
etc...
Now, what I want is to delete the value in column B if th
corresponding value in column A is not 5. This doesn't seem to b
difficult, but the problem is that I want the value in column B t
return to default value if it's corresponding value in column A i
changed back to 5. Is this possible

--
Message posted from http://www.ExcelForum.com