I am trying to create a formula which helps me calculate a median with data that must belong to certain lines in which two categories appear. An example would be the following:
Column T: brand nameColumn AC: Time of the Year
The idea would be to be able to calculate the median of all data which belong at the same time to T (Microsoft) and AC (Summer).
My plan is to make two drop down lists which would serve as selectors in the final table.
Were anyone to have any clue on how to do so I'd appreciate some help :)