N
nikos
Hi.
Let’s say I have two columns in Excel in which the first includes capital
letters A, B, C…. and the second general numbers 2, 3, 77, etc.
In the first column apply merge in the successive cells that have common
letter. In the second cell I don’t do anything. After that when apply filter
from menu and choose a letter (A for example) the appears only the number of
the first row.
For example lets say that the first cell, in the first column (after merge)
has the A letter and in that letter corresponding the numbers (successive
cells) 5, 7 and 9. When apply filter from menu appear only the cell with the
number 5 and not all (5, 7, 9)
Is there any way to appear all the number fields in merged cells or must try
another technique?
Thank you.
Let’s say I have two columns in Excel in which the first includes capital
letters A, B, C…. and the second general numbers 2, 3, 77, etc.
In the first column apply merge in the successive cells that have common
letter. In the second cell I don’t do anything. After that when apply filter
from menu and choose a letter (A for example) the appears only the number of
the first row.
For example lets say that the first cell, in the first column (after merge)
has the A letter and in that letter corresponding the numbers (successive
cells) 5, 7 and 9. When apply filter from menu appear only the cell with the
number 5 and not all (5, 7, 9)
Is there any way to appear all the number fields in merged cells or must try
another technique?
Thank you.