Good morning All !!!!
Good morning All !!!!
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,
Hello rahulonline,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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
![]()
![]()
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE![]()
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks