Posts by kulshresthazone

Re: Formula to compare 2 new lists and return a Value

As per your worksheet data. I tried using this formula .

=SUMPRODUCT(--ISERROR((MATCH($C$3:$C$16,$A$3:$A$11,0))))

[COLOR="#0000CD"]MODERATOR EDIT[/COLOR]
Please do not quote entire posts. When quoting follow these guidelines

1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
2. Quote ONLY the specific part of the post that is relevant - - not the entire post.

This will keep thread clutter to a minimum and make the discussion easier to follow. Quote deleted.
Thanks

Re: Find Last Row in Array with Multiple Criteria

Quote from Dave_Mc;671863

I have a table that looks like this:
C1 C2 C3
A NY 100
A NY 250
A NY 300
A NY 400
A NY 500
B LA 60
B LA 90
B LA 120
B LA 150
B LA 180
B LA 200

I want to pull the last value in column C when the criteria match. Ie: A and NY result is 500; B and LA result is 200.

Any ideas?

Thanks

Display More

You Can try this formula , where A2:A12 represent C1, B2:B12 represent C2, C2:C12 represent C3.
=SUMPRODUCT(MAX((A2:A12="A")*(B2:B12="B")*C2:C12))

Re: Return active OLEObject in Worksheet

You Can make use of Application.Onkeys.
Application.OnKey "{TAB}","KeyCapturing"
Application.OnKey "{ESC}","Rangeselect"

In the first on keys whenever a user press tab button the KeyCaputring macor will be called. and in case of second onkeys event rangeselect will be called.