Hi team, I am having difficulty working out the median age for each occupation in the list attached.
i.e. manually I know the median age for occupation 1 in column B should be around age 46 but I need a formula to use over many different columns and to get an accurate age for each.
Thanks.
i.e. manually I know the median age for occupation 1 in column B should be around age 46 but I need a formula to use over many different columns and to get an accurate age for each.
Thanks.