View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hoosier data hoosier data is offline
external usenet poster
 
Posts: 1
Default formulas in cells change when using filter function

column L uses a 'countif' formula to determine the number of times a specific
# appears in column F. after formulas were entered, i filtered the data, and
the range for many of those formulas changed. how do i fix this?