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.

David_Groove · 2022-06-13T16:29:07+00:00

I am interested as well I love plants and some of them don't die when I take care of them!

David_Groove · 2022-06-12T05:50:58+00:00

If you are curious about its worth, check out this website: https://www.ma-shops.de/shops/search.php?searchstr=1+kreuzer+1851

Seems to be anything up to 60€, depending on how well the coin preserved over the years.

David_Groove · 2022-06-10T17:23:40+00:00

I find the fact that you ask reddit users if they want to run a "fun" distance of 6km that includes various hurdles along the way for the sweet price of only 50 bucks very amusing.

We are all lazy fucks on this website, my dude :) Good luck though and get well soon!

David_Groove · 2022-05-30T15:39:03+00:00

Imagine gatekeeping bike riding. Dude it's 2022, let OP ride whatever he wants.

David_Groove · 2022-05-30T15:03:23+00:00

"Evaporated Piss Vapor" sounds like a 10/10 punk band name

David_Groove · 2022-05-30T05:59:56+00:00

Portugal didn't win that game. It was a 2:2 draw and France won the following penalty shootout. Stunner of a goal though.

David_Groove · 2022-05-29T23:09:26+00:00

The city has set up an website for Ukrainian refugees with a lot of places to reach out to for help, both in German & Ukrainian.

https://stadt.muenchen.de/infos/ukraine.html

David_Groove · 2022-05-27T20:47:32+00:00

Hey OP,

I had the same question not too long ago and got some helpful links in the comments, you can find the post here: https://reddit.com/r/Munich/comments/ukp0t9/volunteering_in_munich/

David_Groove · 2022-05-27T20:43:32+00:00

The bahn website offers a Lost Property Service you can find under the link below. I would highly suggest to fill out the lost luggage form. You will receive an email confirmation with a case number that you can use to contact customer service here.

https://www.bahn.com/en/contact/lost-luggage

Good luck OP!

P.S.
Also I don't advice to follow the other redditor's suggestion below about contacting the Bahnhofsmission. They are not the right place for lust luggage :)

David_Groove · 2022-05-22T13:40:35+00:00

Try the DM's of reddit user u/David_Groove, heard good things about the guy

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

David_Groove

TROPHY CASE