Forum Discussion
extract single years from time spans / analyse membership data
Your proposed measure of =F/M is an unusual choice. The female numbers as a percentage of the total would be more easily understood. Also, as the total numbers drop, the metrics become volatile and there is little meaning to be extracted from them. I would suggest
= IF(F+M>9, F/(F+M), NA() )
once you have derived the numbers using COUNTIFS.
Good point.
HansVogelaar @Peter Bartholomew
Hi !
Many thanks for your feedback and solutions!!
The table in the file is only a small subset.
I should have added that at the end there should be a report showing not only the development re gender among all members but also among the different groups (units/subunits)
Additionally, the report should also show how the distribution of the members among the countries changes (also for the total of all members but also among the different groups).
That’s why I thought to split the time range in single years and then use Pivot-tables/charts.
But maybe I getting this wrong in the beginning and should rearrange the original data?
Sorry, for these basic questions. I’m just (re)diving into the world of data analysis/Excel etc..
Your help is immensely appreciated!
