is it possible to work out the modal value of a set of data if it has been filtered?
SUBTOTAL() doesn't allow a mode to be worked out.
eg i have two columns of data and i filter the first column, and i want to know the modal value for the values left in the second.
SUBTOTAL() doesn't allow a mode to be worked out.
eg i have two columns of data and i filter the first column, and i want to know the modal value for the values left in the second.