How to pick last value of particular range

[mohan.r1980]

Hello Friends,

i have range of Names in Column C
Party Name Due On
XYZ Co. 22-03-2017
XYZ Co. 23-03-2017
PQR Co. 24-03-2017
DEF Co. 25-03-2017
PQR Co. 26-03-2017
DEF Co. 27-03-2017
DEF Co. 28-03-2017
PQR Co. 29-03-2017
PQR Co. 30-03-2017
XYZ Co. 31-03-2017
XYZ Co. 01-04-2017
qqq 02-04-2017
qqq 03-04-2017
PQR Co. 04-04-2017
qqq 05-04-2017


i have unique Party Name and on this basic i want to pick the last value of "Due On" Column which is in D
is it possible in Macro ?

Please suggest?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[mohan.r1980]

Hi John,

Thanks for reply

i want this result

Party Name Last Due On
XYZ Co. 01-04-2017
PQR Co. 04-04-2017

means each Party name's Last Date

sorry i didn't mention in earlier post.

[jindon]

Try

Please Login or Register  to view this content.

[JOHN H. DAVIS]

OK:

Please Login or Register  to view this content.

Include in your Module this function as well (written by Rick Rothstein)

Please Login or Register  to view this content.

[mohan.r1980]

Hello Jindon,

thanks for reply

while running i got the error on UBound(a,1) line

Compile error:
Expected array

[jindon]

Assumed the data heading in row1.

[mohan.r1980]

Hello Jindon,

Very thanks for reply

i am trying your script but i am fail to modify in my way.

i am attaching a sample file which i exactly want.
Please read comments on Output sheet that will help you.

once again thanks

[jindon]

Much more complex than your original question.

Please Login or Register  to view this content.

[mohan.r1980]

Much more complex than your original question.

Please Login or Register  to view this content.

Yes, much more complex than original, actually i thought it will be very easy to pick last value because some times i use Vlookup formula for last value i.e

Please Login or Register  to view this content.

but this time its not working, i don't know why?
so i post in that way.

and finally Your solution is superb, i don't have the words to describe you.
its my pleasure that you are helping me.
just keep in mind that i am a big fan of you. i never see the script typing way that you apply.
whenever i visit this site i always follow your post. every time i learn from you.

thank you so much.

[jindon]

Glad you like my codes, however you should describe the whole problem in the first post.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.