Calculating Median Absolute Deviation and Modified Z-score

Hi there, I'm working with a relatively small data set, so in order to better identify outliers I'm looking to calculate the modified z-score. However, in order to do that, I must first calculate the median absolute deviation (MAD). Can someone please help explain how to do this AND show an example of how to calculate it in Excel? Thanks in advance!

=MEDIAN(ABS(values - MEDIAN(values)))

The formula MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.

So, for each value, I will subtract it from the median to get the absolute deviation from the median for each value. Then, I will find the median of the absolute deviations from the median, ...

Yes, that's what the formula does:

	A	B	C
1	78.7	0.0	B1: =ABS(A1-$A$10)
2	76.5	2.2
3	76.6	2.1
4	78.7	0.0
5	78.4	0.3
6	93.2	14.5
7	87.3	8.6
8
9
10	78.7		A9: =MEDIAN(A1:A7)
11		2.1	B10: =MEDIAN(B1:B7)
12
13		2.1	B11: {=MEDIAN(ABS(A1:A7 - MEDIAN(A1:A7)))}

... and use that when calculating the modified z-score.

I don't know anything about z scores.