Excel 07 filter
 

using excel 07 i have a large file and am running into a problem on occasion.
if i do a customer filter by text off of column A and then in column B i put
some text that applies to the filtered items in A. but when i clear the
filter some times it has the proper text from B applied to the correct items
in A and some times not. It looks like when i take the filter off the filter
was not being applied to B and the text just stays in the same order. The
part i can't figure out is sometimes it works fine and i don't see myself
doing anything different. Anybody have any idea why this is