Hello All,
Having some trouble here. I did find some Median If topics, but unfortunately I was unable to get it to work for my situation. I've tried Median with nested if statements and IFS. No luck. I'm trying to return the median value of a column of numbers if the date from another column falls within a range (quarterly). Essentially, I've got a year worth of data and I want to return the median value for each quarter. Hopefully that makes sense. Sorry, excel noob here
In the attached example I want to return the median of column A if Column B falls between two dates (beginning of the quarter and end of the quarter). Ideally, I'd like it to work so that I don't need to specify the number of rows each time as well (dynamic?)
Thank you in advance!
Scott
Bookmarks