Hi all,
I have a formula that pull back the median from a list of values:
=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median Analysis'!G$4,'Median Gender Pay Gap'!AI:AI))
In order for to work I need to add the brackets back in: (like below)
{=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median...