Hey!
I want to find a formula that do the trick to find the last incident of a value or text. Lets say we have five different salers, and want a column where the last value or text is shown.
So the formula should search in the column "SALER" and the last date with this saler and show the result in a cell.
I have made a sheet where I try to show you the problem. In the "LAST SALE" column the value of last sale for the saler should be. And the search for it should be based on the names and dates in column A and B.
Hope you understand the problem.
Thanks in advance!
Anthony Moody
Bookmarks