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... ...
No doubt you do need a VBA solution but I am curious to know why when there are simple worksheet formulas available to perform the same task.
= XLOOKUP(distinctItems, sales[Items],sales[Dates],"",0,-1)
Hi;
I have all lookup and related formulas in the sheet... Due to huge data, sheet is now touching 28MB... Need to migrate to VBA to improve sheet calculation time...
I have all lookup and related formulas in the sheet... Due to huge data, sheet is now touching 28MB... Need to migrate to VBA to improve sheet calculation time...