I think I would try using the MAXIFS function. If your names are in column A and dates in column B and you put a new column of names in D (copy and pasting and removing duplicates and sorting, or whatever) you can enter "=today()" in E1 and use the formula =MAXIFS($B:$B,$A:$A,$D2,$B:$B,"<"&$E$1) to get the last date before today in column E and =MAXIFS($B:$B,$A:$A,$D2,$B:$B,"<"&$E2) in column F to get the previous to last date
Now you can luxuriate in a nice jail cell, but if your hand touches metal, I swear by my pretty flowered bonnet, I will end you.
Mal ,'Our Mrs. Reynolds'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
-t - Mar 19, 2021 9:48:03 am PDT #25423 of 25496
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
meara - Mar 19, 2021 10:34:37 am PDT #25424 of 25496
Dcp, I can sort, but if I have 10 or 15 names, it makes it hard to see, which is why I wanted a formula or table—otherwise I’d just have to sort and then filter for each name and manually enter the info. Doable for a few names, not so much when it’s a bigger list.
meara - Mar 19, 2021 10:47:33 am PDT #25425 of 25496
Thanks t, I’ll give it a shot!
Volans - Mar 24, 2021 3:53:14 pm PDT #25426 of 25496
move out and draw fire
Are Duck Donuts a thing anywhere else? The business model is a doughnut topped with stuff, like bacon. link
amych - Mar 24, 2021 3:57:00 pm PDT #25427 of 25496
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
I LOVE Duck Donuts.
They have a bunch of locations around NC (the Duck in the name is the teeny-tiny town of Duck on the outer banks, not an actual avian duck), but I don't know if they've gone much further afield.
Maria - Apr 13, 2021 3:00:34 pm PDT #25428 of 25496
Not so nice is that I'm about to ruin a Friday morning for a bunch of people because of a series of unfortunate events and an upset foreign government. - shrift
Popping in very quickly with a request (cross-posted with Natter): Facebook has disabled my account and given me 30 days to request a review. Does anyone have tips or tricks to get it back? Thanks.
Laura - Apr 15, 2021 12:15:32 pm PDT #25429 of 25496
Our wings are not tired.
Does anyone use and like some kind of inter-office messaging type system? One of my practices was using a messenger program to send messages from reception to the various individuals and groups, but it is ancient and I can't support it. Biggest issue is that it runs on the desktop but users are usually in cloud sessions and the message doesn't pop up on top of the remote session and just sits hidden on the desktop.
NoiseDesign - Apr 15, 2021 3:19:29 pm PDT #25430 of 25496
Our wings are not tired
I've been using Slack for quite a few years and it's been pretty effective.
Laura - Apr 15, 2021 4:24:59 pm PDT #25431 of 25496
Our wings are not tired.
I played with Slack a little but it wasn't giving me the kind of pop ups I was looking for.. It could be just a configuration of notification thing. I might spend some more time with it this weekend.
NoiseDesign - Apr 15, 2021 9:40:48 pm PDT #25432 of 25496
Our wings are not tired
There are a lot of integrations available for Slack so you might be able to use something to make a more prominent notification. I know that I get prompted about Slack messages in the App on my computer, and then a notification that buzzes my phone, and also one that buzzes my watch.