MINIF and MAXIF values in range help

i am looking to calculate the max and min value in a range which is both dependent on a text value (long /short) and swaps min max value calculation based on long short direction
see attached workbook example

i know the formula should include MAXIF and MINIF formula over a given series of data and conditional statements.

example file attached in excel 2019 version

example file includes desired values in cells in column M and N
comments and clarification saved in cells M16, N16, M18, N18, M20, N20

Thanks in advance for your help!!

Are you still using Excel 2016?

Pleae update your forum profile - it's out-of-date.

I have been looking at it, but haven't yet found a solution, If I do, I'll let you know.

Hii.

M2:
=IFERROR(IF(L2<>"entry/exit","",IF(K2="short",MAX(INDEX(E:E,AGGREGATE(14,6,ROW(L$1:L1)/(L$1:L1="entry/exit"),1)):E1),MIN(INDEX(F:F,AGGREGATE(14,6,ROW(L$1:L1)/(L$1:L1="entry/exit"),1)):F1))),"")

N2:
=IFERROR(IF(L2<>"entry/exit","",IF(K2="short",MIN(INDEX(F:F,AGGREGATE(14,6,ROW(L$1:L1)/(L$1:L1="entry/exit"),1)):F1),MAX(INDEX(E:E,AGGREGATE(14,6,ROW(L$1:L1)/(L$1:L1="entry/exit"),1)):E1))),"")

both copied down.

I'll have a look in the morning. It's evening here, and time to eat.

A bit of a guess, as your picture didn't attach properly (a file is ALWAYS preferred t a non-editable picture of a file, btw)

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

No problem! Files are much more useful than pictures...