[ SECRET POST #3125 ]

[case]

⌈ Secret Post #3125 ⌋

Warning: Some secrets are NOT worksafe and may contain SPOILERS.

01.


__________________________________________________



02.


__________________________________________________



03.


__________________________________________________



04.


__________________________________________________



05.


__________________________________________________



06.


__________________________________________________



07.


__________________________________________________



08.


__________________________________________________



09.


__________________________________________________



10.











Notes:

Secrets Left to Post: 03 pages, 066 secrets from Secret Submission Post #447.
Secrets Not Posted: [ 0 - broken links ], [ 0 - not!secrets ], [ 0 - not!fandom ], [ 0 - too big ], [ 1 - repeat ].
Current Secret Submissions Post: here.
Suggestions, comments, and concerns should go here.

Comments

Libreoffice Calc

[(Anonymous)]

I know this is a long shot, but does anyone know how to take a list, and see how many things are on that list in Libreoffice Calc?

Like, say I have a list of fruit:

Lemon
Grape
Apple
Lemon
Watermelon
Lemon stealing whore
Grape
Apple
Lemon

And I want to see how many of each type of fruit I have (3 Lemon, 2 Grape, 2 Apple, etc.) how do I do that? Does anyone know?

Re: Libreoffice Calc

[(Anonymous)]

Think you might need to use pivot tables?

IDK tho, I don't really fuck around with spreadsheets much anymore

Re: Libreoffice Calc

[(Anonymous)]

Late reply, and been a looooooong time since I had to figure out formulas, but have looked at using SUMIF statements?

Re: Libreoffice Calc

[(Anonymous)]

If I just needed the numbers and didn't need to do it the 'proper' way for an assignment or something, AND if this Libreoffice Calc has all the same functions as Excel, I would filter the list for each category of thing I needed and just count the results of each feature.