sydney

  1. U

    In cell H7, use an appropriate formula to add the total sales made in Perth for all the years. But I've decided to make the Formula to be independent

    <colgroup><col span="3"><col><col span="2"><col><col></colgroup><tbody> Artist Place Year Sale Taylor Swift Sydney 2013 $ 3,067.00 Big Shaq Melbourne 2009 $ 3,119.00 Ed Sheeran Sydney 2017 $ 3,216.00 Coldplay Brisbane 2007 $ 3,286.00 Taylor Swift Brisbane...
  2. N

    INDEX MATCH duplicate value issues

    Hi everyone I'm having a few issues with duplicate values. In column E below the Sydney value keeps getting repeated. Any tips or better formulas would be much appreciated! <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page...
  3. J

    DAX Measure to rank by category and subcategory

    Hi, I have loaded a table (named "Data") into Powerpivot and would like a measure to rank by Product in each city using a ref number. I also want this rank to stay even if I filter later. <tbody> City Product Ref RANK I want Sydney Bike 100 1 Sydney Bike 102 2 Sydney Bike 105 3...
  4. N

    merge data from multiple columns to single - vba help

    hello, I ve a spreadsheet in following format and looking to merge columns and make it to single. Current: <tbody> User Location Vendor CBOT CME NYMEX COMEX Brian Hoyer New York CQG 1 1 Sydney Chen Los Angeles CQG 1 1 1 Ram Nivas Dallas CQG 1 </tbody> Desire Output if cbot or...
  5. J

    CountIf on non contiguous named range

    Below is a set of data I am working on. I have named the customer satisfaction range as "CustomerSatisfaction" then i have applied a filter on the cities ie filter by "Melbourne" then i have named the customer satisfaction column with the filter on and called it...
  6. M

    Register: ModelOff APAC Meetups 2015 (AUS, IND, HK, SG)

    This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations! Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...

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