RSS 12 Comments…

 Share your views
  1. VERY helpful, VERY simply and well explained!

  2. Thanks in Advance,

    Would also like to know

    1.If I drag some fields at Pivot, In my source document How do I identify which fields I have selected - any trick to Highlight - Identify them
    2. How do I identify at Pivot, in my source data which filed Header names have been changed?, seems my pivot stops refreshing : A message saying your source data field name has been changed
    Please email me

  3. Your formula is great but only works with unique values, if you repeat the same letter (i.e. "E") and hide the first value of "E", you will get the hidden value, so it doesn't work in this case.
    would a definite solution to this?.
    Thanks.
    Audie

Leave a Comment

Your email address will not be published.

*

*