australia

  1. E

    Filter values in a pivot table

    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...
  2. C

    Text to column formulas with multiple line break delimiters

    Hi All, I am looking for some assistance with developing a formula to break up a cell into multiple columns. I have 4 lines to the cell. i need to combine line 1 and 2, break up line 3 into 3 separate cells and then delete the 4th line. I am looking for a formula as I am working on a template...
  3. U

    vba arrangement of data

    I have a file with 3 columns consisting of dates, companynames and costs respectively. I have developed a VBA forecasting model which I want to useon this data. However I want to arrange the data into the form I need,which is 2 columns consisting of months and costs, but with the rows of...
  4. T

    Apply filter on the basis of multiple values

    I have this data . <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Country Name India A India B India C Australia D Australia E Peru F Peru G Chile H Chile I </tbody> Now I want to apply...
  5. O

    Fill in the blanks...

    How in VBA can i fill in the blank rows and fill them...it needs to find the name after the blank and copy both fields to the above cells. Appreciate any help :) So from this..... <tbody> V00006 Action Office Machines P/L V03393 Active Sound Services V03271 Adaptalift Group Pty Ltd...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top