cortexnotion
Board Regular
- Joined
- Jan 22, 2020
- Messages
- 150
- Office Version
- 2013
- Platform
- Windows
Hi All,
I have a range A2:A75. I need a formula for the following:
For cells than are greater than 0, I need to count any value that appears more than once in the range. I need to count the 1st appearance of the value in addition to the duplicates.
Many thanks for your help
I have a range A2:A75. I need a formula for the following:
For cells than are greater than 0, I need to count any value that appears more than once in the range. I need to count the 1st appearance of the value in addition to the duplicates.
Many thanks for your help