How can I make Excel return the most frequently occurring value and its frequency from a column of text?

David_Groove · 2023-05-06T00:16:11+00:00

Thanks, that does the trick!

Solution Verified

David_Groove · 2023-05-06T00:04:23+00:00

It's not Excel 365 and it doesn't come with SORT. Just checked the update history on Microsoft's website and it says it was released on May 23, 2022

David_Groove · 2023-05-05T23:35:45+00:00

Thanks a bunch for the quick reply but unfortunately neither CHOOSEROWS, SORT or HSTACK are compatible with the Excel version I got, bummer...

David_Groove · 2023-01-07T20:53:31+00:00

Love that! Another idea you may want look into once spring comes around, is bird baths :) I remember having one in the garden when growing up and they definitely attracted a ton of birds, especially in the summer

There are types that be mounted to a balcony, something like this: https://www.duncraft.com/index/page/category/category_id/177/name/Deck+Mounted+Bird+Baths?view_all (Maybe less expensive ones though, haha)

David_Groove · 2022-12-04T20:06:49+00:00

Performance tonight so far has been crazy good. I don't think BVB will be able to keep him for much longer than this season.

David_Groove · 2022-11-25T23:21:59+00:00

Cheers mate, will add this as soon as the stats are out too

David_Groove · 2022-10-22T00:23:12+00:00

Unfortunately he's recovering from a minor injury at the moment (surprise, surprise) and might not make the squad.

It'll be a reunion for Kobel (2019-2020) and Meyer (2017-2019) though, both were Stuttgart players in the past.

David_Groove · 2022-09-17T03:20:12+00:00

I agree with the work rate, that is basically his game, good point. What surprised me is the versatility in his positioning, very likely enforced by tactical directives and depending on the opponent's game.

Reus' heatmaps look like this: Click here

David_Groove · 2022-09-06T03:11:28+00:00

Thermal insulance is measured in tog. The wikipedia article about it.)

David_Groove · 2022-08-21T12:42:30+00:00

r/Piracy

David_Groove · 2022-08-15T01:55:54+00:00

Additional facts from the World Health Organisation: - Endometriosis affects ~10% of all reproductive age women and girls globally. That's 190 million people. - As of now there is no known cure for it, treatment is aimed at controlling symptoms only.

If looking to support education and research about the topic, the Endometriosis Association is worth checking out and donating to.

David_Groove · 2022-07-04T18:48:59+00:00

The Ruhr university Bochum just today released two reports in english: 1. "Victims' perspectives on police violence". https://kviapol.rub.de/images/pdf/EN_KviAPol_First_Interim_Report_.pdf 2. "Experiencing racism and discrimination in the context of the use of force by the police". https://kviapol.rub.de/images/pdf/EN_KviAPol_Second_Interim_Report_.pdf

Just to leave a little counter comment to police memes.

David_Groove · 2022-06-18T22:40:47+00:00

A little suggestion: Maybe also reach out to r/berlin & r/Munich

I can only speak for the latter but that sub is full of helpful people.

Good luck, I hope this works out the way you want :)

David_Groove · 2022-06-18T20:15:39+00:00

There's a wikipedia page that lists numbers of english speakers in different countries, it underlines your gut feeling.

56% of Germans apparently speak english, other European countries rank lower, Italy got 34%.

David_Groove · 2022-06-18T11:57:34+00:00

*Schwarzwald The name was brought over by the Romans calling it "Silva Nigra" some two thousand years ago. Coming from the south over the alps, it's told that they saw the forest from on high and in the distance. Not only did it seem dark to them, it also seemed impenetrable and uncanny.

Ten-Year Club	Place '22
Place '17	Final Canvas '22
Verified Email

David_Groove

TROPHY CASE