Forum Discussion
Pulling certain data in a pivot table
Want to create a pivot table that provides the count of data when a cell contains A, B, or A and B.
**note - the cells being referenced have multiple values in each
(example : Display info below...
This is one way to approach this (assuming the numbers are less than 10!):
=IFERROR(CHOOSE(OR(NOT(ISERROR(FIND("1,",A2))),NOT(ISERROR(SEARCH(" 1",A2))))+2*OR(NOT(ISERROR(FIND("2,",A2))),NOT(ISERROR(SEARCH(" 2",A2)))),"1","2","1 and 2"),"None")
=IFERROR(CHOOSE(OR(NOT(ISERROR(FIND("1,",A2))),NOT(ISERROR(SEARCH(" 1",A2))))+2*OR(NOT(ISERROR(FIND("2,",A2))),NOT(ISERROR(SEARCH(" 2",A2)))),"1","2","1 and 2"),"None")