Hi all,
I want to find the median of a set of data but exclude any "0"s from the median calc, like I did with the "averageif" formula. Any ideas?
Thanks!
ex set of data
200
232
0
150
10
411
0
Hi all,
I want to find the median of a set of data but exclude any "0"s from the median calc, like I did with the "averageif" formula. Any ideas?
Thanks!
ex set of data
200
232
0
150
10
411
0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks