Excel remove score data from Index column values

Question

Hello all;

I have a formula that returns the highest sales values located in column W. Works great.

=LARGE('AGGG .com POS report MS'!$W$2:$W$500,ROWS('AGGG .com POS report MS'!$B$20:B20))

Top Items Sales $
7116.44
5153.59
2182.06
2101.28
1353.5
1197.6
1128.37

I then have an INDEX formula that returns the item name for each of the value results mentioned above:

=INDEX('AGGG .com POS report MS'!B20:B40,MATCH(MAX('AGGG .com POS report MS'!W20:W40),'AGGG .com POS report MS'!W20:W40,FALSE),)&" Scored "&MAX('AGGG .com POS report MS'!W20:W40)

Top Selling Items
Item One Scored 7116.44
Item Two Scored 5153.59
Item Three Scored 2182.06
Item Four Scored 2101.28<br><br><br><br><br><br>Since I already have the values in an adjacent cell I want to removed the word "Scored" and amount from the resulting values and just show the items. Is there additional syntax I can add to the formula so that it does not appear?<br><br>Thanks<br><br>Rob

Answer 1

Shorten the formula to

=INDEX('AGGG .com POS report MS'!B20:B40,MATCH(MAX('AGGG .com POS report MS'!W20:W40),'AGGG .com POS report MS'!W20:W40,FALSE),)

Answer 2

Hi Rob Ingles,

Have you referred to the reply provided by MVP above? Please let us know if you still need any further help.

Best Regards,

Waqas Muhammad