Dear all,
I have data in which customer wise,date wise product sale price is mentioned. When I filter it with particular party for a particular product for example in my sheet 79-017901, and use find function it shows result from starting date,then after pressing enter it moves to latest dates.
So my question is how to find sales price for a particular customer for particular product with most recent date sale price easily.
Thanks in advance.
Dev.
It depends how you wish to do it, if it is by the filters so you filter for customer name and Item name, you can sort by igpdt descending, the top line will be the most recent date
The problem is that you have more than 1 sale to the same customer on the same date, so which value would you wish to take eg if the 29th mar was the most recent date in the example, what would you wish to return?
I'd do this totally differently. This is a very basic version of what can be done. Take a look and see if it's what you need. It returns a blank if a product line has never been ordered by a customer before. Otherwise, it returns the latest value.
It can be tidied up a lot to make it much more adaptable, but I'm not going to spend any time on it, if it's not what you're after.
Use the drop-down boxes in G & H to get a result in I.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Apols. It returns a #N/A if there's no match. I can make it return a blank if/when I make the whole thing more robust.
If you convert your dates to numbers instead of text,
=SUBTOTAL(4, B:B) will give you the greatest date after filtering.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you all,
I will try your solutions and will let you know.
Dev.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks