6 Replies Latest reply on Feb 2, 2012 10:21 AM by David Drees

    Determining if all values are the same

    David Drees

      I have a table of text values.  For example, I have columns listing products and rows listing US states.  In the cells, the data display a text that is either "Active" or "Inactive" indicating whether or not we currently offer that product in that state.  What I want to do is view only those rows that have some products Active and some products Inactive.  If all cells on the row are "Active" or all "Inactive" then, I don't want to see those rows.

       

      I've tried several different table calculations, but nothing seems to work.  Any ideas?

       

      In the sample I've attached, I would want to see all rows except the row for CA and the row for GA.