View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie Martin
 
Posts: n/a
Default Auto Extended Formula not working

Does the auto extend list for formulas not work with this type of formula:
=COUNTIF($L$3:$L185,$L185) ?? I have another formula in the same
worksheet, which is: =IF(Q185="","",S185-T185) and the auto extended formula
function works with it when new data in typed in the next empty row, but
won't for the other formula. Any answers? Connie