What's the best way to do this? VBA, etc
I want to do is to calculate average overdraft days for last 4 recent months, so for feb and mar, there is combined of days,which i want to keep to use for average but remove months associated with combined (or else avg will be calculated incorrectly), so i need help with a code that will loop through each Fund_ID(remove the duplicates),return the 4 most recent bank name along with the associated value for the overdraft days. So in this case, output should look like this: output should look something like this