brazil

I have several files that I use every month. I have two sheets which include the current month that I am working on. For example, I'm starting the November file and I need to rename a couple of these sheets from Sept to Oct (I do commissions so we I am preparing the Oct commissions to be paid...

Hi, I am struggling to filter Values in this example of a pivot table. I want to remove all channels from the pivot that are less than $100 in total not by country. i.e. when I apply the filter I should see some country channels line in this data that are less than 100 because that channel will...

Hi everyone, I have a table similar to the following one, but contains thousands of rows. <tbody> Country ID Brazil Belgium Russia Russia 100 Belgium 300 Brazil 200 </tbody> Each cell in column A has a Sale ID in Column B, but some of them are empty (in column B). I would...

Hi all I have the following input data that I need to be able to group them into Output PowerPivot 1 and Output PowerPivot 2. The below example is just a simplified version but I would have thousands of row and different column. Could you please help to suggest a method. Really thanks...

Hello, I am trying to calculate modified duration for an instrument that uses the day count convention BUS/252. BUS refers to the number of business days in the country (Brazil in my case - 246 BUS in 2015). How could I adjust the MDURATION function in Excel for this different day count...