scoobyblue
Active Member
- Joined
- Jun 30, 2004
- Messages
- 380
Column C cells have either 0, 1, 2, 3, 4, 5 or 6 (Sectors) entered and Column K has text entered ("Reviewed") but some cells will be blank.
I want to be able to count the number of occurrences where text is entered in col' K for 0, 1, 2, 3 etc. Basically, how many of the different Sectors have been reviewed.
So by having a different Cell that can be changed to any number from 0 to 6, another cell would always show the relevant number of matches where they have been Reviewed (this text is input into the ActiveCell in Col' K when a macro is run).
Hope it makes sense, thanks for your help.
Stewart
I want to be able to count the number of occurrences where text is entered in col' K for 0, 1, 2, 3 etc. Basically, how many of the different Sectors have been reviewed.
So by having a different Cell that can be changed to any number from 0 to 6, another cell would always show the relevant number of matches where they have been Reviewed (this text is input into the ActiveCell in Col' K when a macro is run).
Hope it makes sense, thanks for your help.
Stewart