Hi,
I have a dataset with two columns, one with textual values and one with numerical values.
I would like to calculate the median and modus for the range that has cells that do not contain the value "-".
I know that for calculations for cells with "-" i used the function:
=MEDIAN(IF(Z:Z="-";AR:AR;""))
How do i do this for the cells with text in it?
Any input is welcome!
Bookmarks