Been searching the internet for an answer on this one, but still haven't had much success....I have two columns of data. Column A is composed of text values (dog, cat, dog, bird). IE A1=dog, A2 = cat, etc..then column B is also text (C, D, C, E). IE B1= C, B2=D etc..I want to put a a formula above my values in column B to count if value = "C" while using an autofilter on all the data so I can filter to just the values in column A. That is when I have filtered to "cat" in column A my countif formula in column B should equal 0 since only the "D" value in column be is showing. Can anyone help with this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formulas in autofilters
- Thread starter scharf5
- Start date
