Hi,
New to this forum so hope this makes sense.
Is it possible to use LARGE, INDEX and MATCH together in a single formula with no helper column?
For the above:
I need to be able to have two groups of 4 names from any of the 8 names.
Group 1 and group 2 are just examples I have chosen but it could be any combination of names in the groups.
For each group of four names I want to be able to look up each name and their score and then sum the largest two scores for the group.
I am trying to find a formula that does not use a helper column.
Thanks for any help
Steve
New to this forum so hope this makes sense.
Is it possible to use LARGE, INDEX and MATCH together in a single formula with no helper column?
For the above:
I need to be able to have two groups of 4 names from any of the 8 names.
Group 1 and group 2 are just examples I have chosen but it could be any combination of names in the groups.
For each group of four names I want to be able to look up each name and their score and then sum the largest two scores for the group.
I am trying to find a formula that does not use a helper column.
Thanks for any help
Steve