Search results

Luke, Chiba, thank you both very much. I ended up using Luke's code however. The only addition I would make, is to add: Dim C as Variant Once that was done, it worked perfectly. Best Mark

Kchiba, Thank you immensely. I am out the next two days, but will report back on Monday how my tweaking it goes. -Mark

Yes, I am relatively strong on interpreting VB after the fact and then modifying it to fit my needs. Creating it from scratch, not so good.

just realized I used a '>' (greater than sign) to denote just an arrow in the previous post. it should just be a arrow/pointer.

More information required, what is known, do you know the unique values in VALUE1 and VALUE2 ? Value 1 > Yes. Value 2 > which one is used is dependent on which of the associated values in column Value 3 add up to.

So, in the sample above, what I'm essentially trying to recreate is the logic that says IF Value 1 = A, Value 2 is provided, but which one, when summed with other Value 2s that are the same is the 2nd largest is unknown. Value 1 Value 2 Value 3 A ABC = 11,500,000 (the...

Yes. In the example I laid out, I want the 2nd largest item based on the sum of all items where Value 2 is the same, and where Value 1 = A. So that means we exclude anything with 'B' in the Value 1 column.

Hi Kchiba, Thanks for responding. You are correct, a pivot table does work, and it is the current solution. However, the # of items which require this same type of solution is about to increase significantly for me, and I was seeking to prevent a workbook from being swallowed by sheet...

Hi Luke, Thanks for responding. Unfortunately that will not work, because it assumes that I know in advance that 'ABC' is the 2nd Largest Value. The assumption that needs to be made is that I do not know what value of VALUE2 is the largest.

Hi and thank you in advance for the help. I have attached a small mockup of the dataset I am working with. I have been trying to use a combination of SUMPRODUCT & LARGE TO find in the dataset the 2nd largest value, summing on value 2, where value 1 = A. For example, the 2nd largest value...