Ask Your Question
0

Filtering of text column in Pivot Table [closed]

asked 2018-03-27 13:42:41 +0200

Marcin Kr gravatar image

updated 2018-03-27 13:43:30 +0200

Hello, I have a Pivot Table where I want to filter data by one column which contains the codes separated by space. Example:

Column 1, Column 2, Column 3

1, 2, "A B C"

2, 5, "B C D"

3, 8, "C D E"

All of this data is located in the Pivot Table and for example I want to get all rows, where "Column 3" contains code "B". How can I do that?

Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Marcin Kr
close date 2018-03-29 12:17:03.902981

2 Answers

Sort by » oldest newest most voted
0

answered 2018-03-27 16:20:35 +0200

erAck gravatar image

Under Data -> More Filters -> Standard Filter... with Field name for Column 3 select Condition Contains and Value B.

edit flag offensive delete link more
0

answered 2018-03-29 12:16:32 +0200

Marcin Kr gravatar image

It was easier than I thought. Thank you!

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2018-03-27 13:42:41 +0200

Seen: 122 times

Last updated: Mar 29 '18