BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 333
- Office Version
- 2010
- Platform
- Windows
I would like a total count of items per unique ID. In the image below the total should come to 3, as there are 4 unique IDs, but one unique ID has no data.
It doesn't matter what the data values are in column C. Only that it doesn't count blank cells, i.e. ID 4 has no data in any of the cells in column C so should not be counted.
I just need to find out how many IDs have data regardless of what the dat maybe.
It doesn't matter what the data values are in column C. Only that it doesn't count blank cells, i.e. ID 4 has no data in any of the cells in column C so should not be counted.
I just need to find out how many IDs have data regardless of what the dat maybe.