LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas Aren't Automatically Updating When Cells Change chris Excel Discussion (Misc queries) 6 April 5th 23 02:51 PM
How do I drag formulas so cells stay the same but sheets change? Claire Excel Worksheet Functions 1 October 30th 07 07:03 PM
Using MIN Function on cells containing formulas [email protected] Excel Worksheet Functions 2 August 28th 06 10:10 PM
Any way to filter cells with formulas ? gaftalik Excel Discussion (Misc queries) 4 November 26th 05 05:51 PM
How can I change the colour of cells using an IF function? gctexcel Excel Worksheet Functions 1 January 10th 05 12:38 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"