Thursday, February 14, 2013

Count the number of repeated occurrence in LibreOffice 4 on Debian Linux



Captions:

0:00:00.490,0:00:05.430
>> LibreOffice How-To: Count the number
of repeated occurrence in LibreOffice 4


0:00:06.490,0:00:10.430
>> =SUMPRODUCT($A$2:$A$999=$A2)
This counts the number of occurrence



0:00:10.490,0:00:13.430
>> when the contents in A2 exist
in the range of cells A2:A999.


0:00:13.490,0:00:15.430
>> in the range of cells A2:A999.
Select the formula -> Right-click it -> Copy

0:00:15.490,0:00:18.430
>> Select the formula -> Right-click it -> Copy
In the spreadsheet, select D2

0:00:18.490,0:00:20.430
>> In the spreadsheet, select D2
-> Paste Drop-Down Arrow -> Unformatted text

0:00:20.490,0:00:22.430
>> -> Paste Drop-Down Arrow -> Unformatted text
Enter -> Select D2

0:00:22.490,0:00:25.430
>> Enter -> Select D2
Drag the handle downwards

0:00:25.490,0:00:28.430
>> Drag the handle downwards
4E and 4D do not repeat

0:00:28.490,0:00:30.430
>> 4E and 4D do not repeat
They occur once only

0:00:30.490,0:00:33.430
>> They occur once only
Right-click column D -> Delete Columns

0:00:33.490,0:00:36.430
>> Right-click column D -> Delete Columns
Count the number of unique combinations

0:00:36.490,0:00:39.430
>> Count the number of unique combinations

0:00:39.490,0:00:42.430
>> =SUMPRODUCT($A$2:$A$999=$A2,
$B$2:$B$999=$B2)

0:00:42.490,0:00:51.430
>> This counts the number of occurrence
when the contents in A2 and B2 exist.

0:00:51.490,0:00:54.430
>> Copy the formula -> Select it
-> Right-click it -> Edit -> Copy

0:00:54.490,0:01:01.430
>> In the spreadsheet, click
Paste Drop-Down Arrow -> Unformatted text

0:01:01.490,0:01:09.430
>> Drag the handle downwards
4A and John repeat


0:01:09.490,0:01:13.430
>> Right-click column D -> Delete Columns


0:01:13.490,0:01:17.430
>> =SUMPRODUCT($A$2:$A$999=$A2,
$B$2:$B$999=$B2,$C$2:$C$999=$C2)

0:01:17.490,0:01:23.430
>> This counts the number of occurrence
when the contents in A2, B2 and C2 exist.

0:01:23.490,0:01:26.430
>> Select the formula -> Right-click it
-> Copy

0:01:26.490,0:01:30.430
>> In the spreadsheet, click
Paste Drop-Down Arrow -> Unformatted text

0:01:30.490,0:01:35.430
>> Drag the handle downwards
4A, John and Smith repeat

0:01:35.490,0:01:37.430
>> 4A, John and Smith repeat



No comments: