Dear all master,
I am new to this forum.
While I am currently trying to write VBA code on an Excel spreadsheet with >65,000 rows and over 30 columns.
On one column, which I previously use 'SumIf' on the sheet for calculation on one column, it takes me 1 hour just to drag and for Excel to calculate those values.
As such, I am thinking if I can write a piece of code to handle the similiar calculation and perform calculation much faster.
My set up could be like this:
Col A Col B ($) Col C (Result)
A 1 14
A 2 14
A 3 14
B 4 9
B 5 9
C 6 6
D 7 7
A 8 14
I tried to use For loop to handle this, but without success....cos I always get duplicated result at Col C.
Would very much appreciate if any master could assist me. Thousand of thanks ahead.
Kind regards,
Joseph
Bookmarks