Forum Discussion
Find last occurrence
Dear. I need to have a VBA Script to find last occurrence date of value in excel... I have list of items in Column H and have generated a list of unique from that in column M... Date column in B... ...
Since it absolutely must be in VBA :), here is a simple example in the included file.
Maybe it will help in your project.
I wish you lots of fun and success with Excel.
Hi;
Just wanted to represent my scenario... I have a sorted list of unique from a column (Column M), I want to display last billed date of after matching from the column of data (Column M to Column H) with the date column (Column B)...
Column H has the data from which i have created the column M...
Attached sheet is just giving today's date after any input of data...
Just wanted to represent my scenario... I have a sorted list of unique from a column (Column M), I want to display last billed date of after matching from the column of data (Column M to Column H) with the date column (Column B)...
Column H has the data from which i have created the column M...
Attached sheet is just giving today's date after any input of data...