Hello, I'm trying to transform some formulas into VBA code to make the Excel spreadsheet more efficient as it contains thousands of data.
Is there a way to do the calculation in the provided example spreadsheet by code?
The formula itself works as intended, from column A selects one ID per year based on the date from Column C. If for the same ID there's more than one data entry for the same year, sum those entries values of Column B and if in that year for that ID column D ="ir" or "r" then count as 1 (or sum if more than one entry for the same year)
Example spreadsheet:
test11.xlsx
Let me know if I didn't explain well or if you need any more information, thanks!
Is there a way to do the calculation in the provided example spreadsheet by code?
The formula itself works as intended, from column A selects one ID per year based on the date from Column C. If for the same ID there's more than one data entry for the same year, sum those entries values of Column B and if in that year for that ID column D ="ir" or "r" then count as 1 (or sum if more than one entry for the same year)
Example spreadsheet:
test11.xlsx
Let me know if I didn't explain well or if you need any more information, thanks!
