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)