Home > OS >  Adding more filters to MAXIFS under Google Sheets
Adding more filters to MAXIFS under Google Sheets

Time:10-06

I have the following set of data from Google Sheets:

ROWID       ACCT PRIO  TID     ACTION         TICK          CPRICE  CREATEDATE                                          
1440026     20   1     X3T8K5  X_OPEN_LEVEL   BITMEX:BTCUSD 12000   10/5/2022 13:56:46                                                                  
1993961     20   1     X3T8K5  X_TP_1_LEVEL   BITMEX:BTCUSD 12000   10/5/2022 18:17:12                                                                  
2537954     20   1     X3T8K5  X_TARGET_LEVEL BITMEX:BTCUSD 12000   10/5/2022 18:17:46                                                                  

What I am trying to do is to get the latest ACTION in the set. In this case, it would be X_TARGET_LEVEL since it has a CREATEDATE of 10/5/2022 18:17:46

I had used the following as a start:

= FILTER(KDCAlerts!E2:E10, KDCAlerts!H2:H10=( MAXIFS(KDCAlerts!H2:H10,KDCAlerts!D2:D10, C7)) ) 

It DOES work - but - it depends upon DATE only to find the correct answer. This is not ideal. I need to add in another filter TID (represented as C7) as well.

How can this be done

TIA

CodePudding user response:

A solution like this?

=INDEX(SORTN(FILTER({E2:E\H2:H};D2:D="X3T8K5");1;;2;FALSE);;1)

Change TID filters with C7

CodePudding user response:

try:

=XLOOKUP(D2; D2:D4; A2:H4;;;-1)

enter image description here

  • Related