I am looking to get the last three transaction for each customer. Assume it would be the Max or Large function, but not sure how to arrange it.
See attached spreadsheet. Column E would have the formula..can be as simple as the number "1" so I can filter it. Any ideas? Thanks.
Not sure how you wnat to handle ties but try this in row 2 and fill down
Please Login or Register to view this content.
Give this code a try. At least you won't have to sort your table.
Basically, I generate a reference that only contains the top 3 most recent items for each customer and then do a match/index to mark the transaction.
Please Login or Register to view this content.
Thanks guys, both solutions are good.
Go with scottiex's solution. I over analyzed the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks