Hello All,
I would like to not account for hidden/filtered cells in my array.
=Median(IF($A$2:$A$100=J4,$B$2:B$100))
I looked through the many subtotal median examples but none included the where equal to piece my function has. Any ideas?
Regards
Bookmarks