05-07-2019 11:17 PM - edited 05-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
05-08-2019 03:50 AM
05-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)
05-08-2019 06:05 PM
@Sergei Baklan This works. Thank you.
05-09-2019 05:15 AM
@Spicierboar , you are welcome