Hello,
I'm trying to find an efficient (any) way of find the last entry of a particular kind in a list of entries.
Example: you have 100 rows listing the purchases of 5 differenct car colors. What I'm trying to do is find a formula or VBA code that will return the cell that contains the last entry that was made for a "red" car. You can assume the car color is the first cell in the row.
Thank you in advance.
RF
I'm trying to find an efficient (any) way of find the last entry of a particular kind in a list of entries.
Example: you have 100 rows listing the purchases of 5 differenct car colors. What I'm trying to do is find a formula or VBA code that will return the cell that contains the last entry that was made for a "red" car. You can assume the car color is the first cell in the row.
Thank you in advance.
RF