# Removing Two Highest Values, Columns not in order

1. ## Removing Two Highest Values, Columns not in order

I am trying to workout a worksheet for a British Open Game. The Rules are you pick 6 players, but you only take the best 4. I was able to work out the 1st player because his picks are all in order so it is =(SUM(SMALL(F2:F7,{1,2,3,4}))) but the second player has picks in cells f2:f4 and f8:f10. It comes up error when I try to select them. Please help. Thank you.

2. ## Re: Removing Two Highest Values, Columns not in order

If you create a named range consisting of the two ranges, F2:F4 and F8:F10 and give that a name, like List1, then

=(SUM(SMALL(LIST1,{1,2,3,4})))

would work.

3. ## Re: Removing Two Highest Values, Columns not in order

That will work. Thank you.

4. ## Re: Removing Two Highest Values, Columns not in order

I must be reading this incorrectly ...

I'll post it as it's done now.

I'm assuming that the names in the game/competition are in H23:H27.
In Column G are the individual choices of 6 players, I changed this to use the first 2 letters of the individual names.
In I23 this array formula
Formula:
`Please Login or Register  to view this content.`

Confirm with Ctrl+Shift+Enter not just Enter
Drag/Fill Down

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1