Found the answer on a different forum, Thanks for the suggestion Jeff , here are the 2 codes that ended up working in case anyone was interested.

=IFERROR(LOOKUP(2,1/(MAX(IFERROR(ABS(IF('Power data'!$A$1:$A$2394=A2,'Power data'!$B$1:$B$2394,"")),""))=ABS(IF('Power data'!$A$1:$A$2394=A2,'Power data'!$B$1:$B$2394,""))),'Power data'!$B$1:$B$2394),"")

Attached is the code in action.


The other code that worked is this, it was able to be copied down and left which was nice.

=IF(MAX(ABS(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))))=-MIN(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))),MIN(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))),MAX(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))))

wish i could explain it but its way above my head but here it is none the less

Kevin

Attached Files

Book1.xlsx (10.9 KB, 10 views)