Creating an age or service spread chart
I have an XL2003 spreadsheet containing employee names, departments and dates
of birth. I would like to set up charts showing (a) how many people are in each department and (b) how many people are of each age. -- Dave B |
Creating an age or service spread chart
You could set up a separate table to get the info. List the departments and
use an indirect sumproduct formula such as =SUMPRODUCT((ChecksB=B10)*1) or =SUMPRODUCT((ChecksB=B10)*ChecksD) -- Don Guillett SalesAid Software "Dave Bradshaw" wrote in message ... I have an XL2003 spreadsheet containing employee names, departments and dates of birth. I would like to set up charts showing (a) how many people are in each department and (b) how many people are of each age. -- Dave B |
All times are GMT +1. The time now is 09:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com