Ask Your Question

David23's profile - activity

2017-05-07 13:22:27 -0600 received badge  Famous Question (source)
2017-05-07 13:22:27 -0600 received badge  Notable Question (source)
2017-05-07 13:22:27 -0600 received badge  Popular Question (source)
2016-11-20 09:27:11 -0600 asked a question Multiple Data in Single Cell - Sorting

Houston, we have a problem!

We are making a spreadsheet that, among other things, lists the places where a number of articles are printed. Each article is printed in three places. That means, we have one cell with three data points (we do not want to break this into multiple cells, unless absolutely necessary).

Here is an example (M1 is magazine 1, followed by a page number. I used -- to indicate spaces because regular spacing was not working)

Column 1------Column 2

Article 1--------M1 pg 5, M2 pg 60, M3 pg 12

Article 2--------M1 pg 1, M2 pg 45, M4 pg 90

Article 3--------M2 pg 30, M3 pg 80, M4 pg 20

Is it possible, using filter and sort, or some other method, to filter only those articles printed in M2, and then have them displayed in order of the page number in M2?

Any advice appreciated,

2016-11-20 09:27:10 -0600 asked a question Sorting Multiple Data Points in Single Cell

Houston, we have a problem!

We are making a spreadsheet that, among other things, lists the places where a number of articles are printed. Each article is printed in three places. That means, we have one cell with three data points (we do not want to break this into multiple cells, unless absolutely necessary).

Here is an example (M1 is magazine 1, followed by a page number. I used -- to indicate spaces because regular spacing was not working)

Column 1------Column 2

Article 1--------M1 pg 5, M2 pg 60, M3 pg 12

Article 2--------M1 pg 1, M2 pg 45, M4 pg 90

Article 3--------M2 pg 30, M3 pg 80, M4 pg 20

Is it possible, using filter and sort, or some other method, to filter only those articles printed in M2, and then have them displayed in order of the page number in M2?

Any advice appreciated,