Hi,
I have a spreadsheet containing data for various departments. Example:
Column A contains names of departments.
column B contains different items attached to those departments. Some departments may have 10 items attached to them, others may have 24 items and yet others 22 items etc. Each item is contained in a row. typically,
Row 1 DeptA Swimming
Row 2 DeptA Biking
Row 3 DeptA Rock climbing
.
.
.
Row 24 DeptA Writing
Row 25 DeptB Biking
.
.
Row 36 DeptB Bingo
Row 37 DeptC Bingo
Etc
What formula do I use to count number of rows of items per department?
Thanks
Rauri
I have a spreadsheet containing data for various departments. Example:
Column A contains names of departments.
column B contains different items attached to those departments. Some departments may have 10 items attached to them, others may have 24 items and yet others 22 items etc. Each item is contained in a row. typically,
Row 1 DeptA Swimming
Row 2 DeptA Biking
Row 3 DeptA Rock climbing
.
.
.
Row 24 DeptA Writing
Row 25 DeptB Biking
.
.
Row 36 DeptB Bingo
Row 37 DeptC Bingo
Etc
What formula do I use to count number of rows of items per department?
Thanks
Rauri