May 07 2019 11:17 PM - edited May 07 2019 11:18 PM
Could someone please assist with the following:
Example:
Scale 2 Values are: A1, A1, A1, A1, A2, A2... Main Scale Values 100, 99, 98, 97, 96, 95. So A1 can equal 100, 99, 98 or 97. Only 100 (the highest value) should be displayed.
Your help is greatly appreciated.
Thanks
May 08 2019 03:50 AM
May 08 2019 07:13 AM
Solution@Spicierboar , as variant, for such model
=AGGREGATE(14,6,1/(INDEX(A3:G4,MATCH(B6,A3:A4,0),2):INDEX(A3:G4,MATCH(B6,A3:A4,0),7)=B7)*$B$2:$G$2,1)
May 08 2019 06:05 PM
@Sergei Baklan This works. Thank you.
May 09 2019 05:15 AM
@Spicierboar , you are welcome
May 08 2019 07:13 AM
Solution@Spicierboar , as variant, for such model
=AGGREGATE(14,6,1/(INDEX(A3:G4,MATCH(B6,A3:A4,0),2):INDEX(A3:G4,MATCH(B6,A3:A4,0),7)=B7)*$B$2:$G$2,1)