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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top