geddiknight
New Member
- Joined
- Jun 26, 2007
- Messages
- 18
Hey. Im looking to count the number of times in a table where two cells in a row have certain properties, for example:
i want to know how many times column 4 has "High" written it when (and only when) column 6 has "Black" in it.
could this be done as a formula or would i have to use VBA? if the latter, could someone help me with the code to write - im just learning VBA.
thanks
chris
i want to know how many times column 4 has "High" written it when (and only when) column 6 has "Black" in it.
could this be done as a formula or would i have to use VBA? if the latter, could someone help me with the code to write - im just learning VBA.
thanks
chris