SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,107
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi guys, again
I have spent now 2 hours trying to shorten this formula, please help.
last one now, thanks.
Dave
I have spent now 2 hours trying to shorten this formula, please help.
Code:
=
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=AAX2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,AAX2>ADG!$K$2),1,
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=AAY2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,AAY2>ADG!$K$2),2,
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=AAZ2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,AAZ2>ADG!$K$2),3,
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=AAA2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,ABA2>ADG!$K$2),4,
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=ABB2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,ABB2>ADG!$K$2),5,
IF(AND(LARGE(AAX2:ABC2,ADG!$K$1)=ABC2,MAX(AAX2:ABC2)>LARGE(AAX2:ABC2,2)+ADG!$K$3,ABC2>ADG!$K$2),6,
""))))))
last one now, thanks.
Dave