Hello

[rahulonline]

Good morning All !!!!

[rahulonline]

Good morning All !!!!

[LIST][*] I just want a last selling price of the product sold on last date at highest quantity [*] If the product is not sold on immediately on previous date then formula need to search for the more previous date and need to find the same criteria i.e higher quantity sales price [*] If the product is new or first time appearing in the list then i want to use its price as it is if the quantity is one , But if multi pal on the same date then again higher Qty. price will be applicable for the that day & next time when the item is sold

Regards,

[arlu1201]

Hello rahulonline,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[Doc.AElstein]

Hi rahulonline
Welcome to Excel Forum

This is just the Sub Forum to say hello

You must start a new Thread here if you need help:

http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/

_............................................

Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/showthread...42#post4519006
It is usually worth it in the long run.

Thanks