Hi everybody
I am having some difficulty in coming up with a formula and could really do with some help.
I have 16 columns, split into 8 'category A' and 8 'category B'. These will be filled with numerical values when populated.
The formula I'm trying to work out is to get the sum of the next 3 highest values (of either category A or B), after you have taken out the top 2 category A and top 2 category B values. It's this different category business that I can't get my head round.
As an example the table looks something like this, values simplified and colours added for clarity example table.jpg
Any help or suggestions are much appreciated.
Many thanks.
Bookmarks