• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    pivot table does not give the answer required

    Brilliant, thanks Ariff, problem solved!!
  2. T

    pivot table does not give the answer required

    Thanks for the help. I have looked at the formula and it works if I copy and paste directly but when I make amendments to the formula to adjust for data range it either shows nothing in the cells (the brackets {} disappear when I make the changes) or when I add the {}brackets back in the cells...
  3. T

    pivot table does not give the answer required

    I have a table that has three columns, Col1=customer, col2=product number, col3=customer number. When using a pivot table I get the product number in the x column and the product number in the y row however, the data can only sum the information at the coordinates when I require the customer...
Back
Top