The total number of countries is around 100 (by the way they can partially change every month), everyday I will have around 130 countries but they can be different from the previous day.
I was not able to figure out how to automatically filter for all the available criteria in three columns. Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling work. Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc. and so forth, everything automatically just by pressing a button. Workout Examples 05 Reading data from a microsoft access database and writing it into a text file. It means I want to filter AU, T1 and 35 (Partner TAT) and sumup Rebate Amt, then filter KR, T1, 45 and sumup the rebate amt. On the column headers I have an auto-filter, I would like to automatically filter each country, Tier and Partner TAT and take sum of Rebate Amt.
0 kommentar(er)
