Home

How to create a matrix formula which considers two conditions before performing calculus.

%3CLINGO-SUB%20id%3D%22lingo-sub-683365%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20matrix%20formula%20which%20considers%20two%20conditions%20before%20performing%20calculus.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683365%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20which%20helps%20me%20calculate%20a%20median%20with%20data%20that%20must%20belong%20to%20certain%20lines%20in%20which%20two%20categories%20appear.%20An%20example%20would%20be%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20T%3A%20brand%20name%3CBR%20%2F%3EColumn%20AC%3A%20Time%20of%20the%20Year%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%20would%20be%20to%20be%20able%20to%20calculate%20the%20median%20of%20all%20data%20which%20belong%20at%20the%20same%20time%20to%20T%20(Microsoft)%20and%20AC%20(Summer).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20plan%20is%20to%20make%20two%20drop%20down%20lists%20which%20would%20serve%20as%20selectors%20in%20the%20final%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWere%20anyone%20to%20have%20any%20clue%20on%20how%20to%20do%20so%20I'd%20appreciate%20some%20help%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-683365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
Not applicable

Hi!

 

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 name
Column 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 :)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies