Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If your "number" already is a "family identifier", first sort by it, do as demonstrated in the attached dociument, first sheet, Copy everything, 'Paste Special...' valurs only in a second sheet, rearrange everything as wabted, filter for "Not Empty" in the family column ...
You see?
Of couse you hav still the problem with probably different addresse within a "family". #

Attachment

If your "number" already is a "family identifier", first sort by it, do as demonstrated in the attached dociument, first sheet, Copy 'Copy' everything, 'Paste Special...' valurs only results only in a second sheet, rearrange everything as wabted, wanted, filter for "Not Empty" "not empty" in the family column ...
You see?
Of couse you hav still the problem with probably different addresse within a "family". #

Attachment

If your "number" already is a "family identifier", first sort by it, do as demonstrated in the attached dociument, first sheet, 'Copy' everything, 'Paste Special...' results only in a second sheet, rearrange everything as wanted, filter for "not empty" in the family column ...
You see?
Of couse you hav have still the problem with probably different addresse within a "family".

Attachment

If your "number" already is a "family identifier", first sort by it, do as demonstrated in the attached dociument, first sheet, 'Copy' everything, 'Paste Special...' results only in a second sheet, rearrange everything as wanted, filter for "not empty" in the family column ...
You see?
Of couse you have still the problem with probably different addresse within a "family".

Attachment

Only expected to work correctly with LibO version 5.4.4 or higher!

If your "number" already is a "family identifier", first sort by it, do as demonstrated in the attached dociument, first sheet, 'Copy' everything, 'Paste Special...' results only in a second sheet, rearrange everything as wanted, filter for "not empty" in the family column ...
You see?
Of couse you have still the problem with probably different addresse within a "family".

Attachment

Only expected to work correctly with LibO version 5.4.4 or higher!higher!

===Editi1===
New attachment explaing my recent comment to the question.
(Please add comments to the answer here.)