Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,180
- Office Version
- 365
- 2019
- Platform
- Windows
What I am trying to do is devise a count that will ignore consecutive values and only count them as one, For example if I had the following numbers 1,5,4,4,4,1,2 my count would be 5, I would count the first 4 but ignore the rest. If I had 1,5,1,5 the count would be 4.
Please note that there could be blanks in the range like 1,5, "",1,5 blanks will be ignored so the count still would be 4.
Thanks in advance Stephen
Please note that there could be blanks in the range like 1,5, "",1,5 blanks will be ignored so the count still would be 4.
Thanks in advance Stephen
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Counts Desired | ||||||||||
| 2 | 1 | 5 | 4 | 4 | 4 | 1 | 2 | 5 | |||
| 3 | 1 | 5 | 1 | 1 | 2 | 1 | 2 | 6 | |||
| 4 | 1 | 5 | 1 | 5 | 4 | ||||||
| 5 | 2 | 2 | 3 | 3 | 2 | ||||||
| 6 | 1 | 5 | 11 | 11 | 3 | ||||||
| 7 | 11 | 11 | 2 | 3 | 3 | ||||||
| 8 | 1 | 5 | 5 | 6 | 3 | ||||||
| 9 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | |||
Sheet1 | |||||||||||
