I am looking for functions that will look at a given row and return the max, min, and median of a range based on the criteria from the row in focus. For example, if there is a location, product, and code, I want the function to refer to a dataset with a whole list of competitors, look for the competitors that match that location, product, and code, and return the minimum price, maximum price, and median for that category. I have some functions that seem to be right, but then they end up giving me weird numbers as I fill down further. Also, the min returns nothing but zeros even though I filtered zeros out in the dataset I have the function referring to.
Example workbook attached.. Thanks!
Bookmarks