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... ...
An alternative could be Power Query. You can add data into the blue dynamic table. Then click in any cell of the green table and right-click with the mouse and refresh.