OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Thanks in advance for your assistance. What is the VBA Code to find the no of rows with the same specified values in the columns.
For example, I would like to find the number of rows with "Dog", "Cat" and "Bird, where in the following example, the answer is 3.
For example, I would like to find the number of rows with "Dog", "Cat" and "Bird, where in the following example, the answer is 3.
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Dog | Bird | Cat | ||
2 | Mule | Donkey | Goat | ||
3 | Dog | Bird | Mule | ||
4 | Donkey | Bird | Cat | ||
5 | Dog | Bird | Cat | ||
6 | Snapper | Catfish | Salmon | ||
7 | Dog | Bird | Cat | ||
Sheet1 |