'The Cautionary Tale of Numero Cinco'
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!
Any suggestions for a basic nas/raid/etc. would be appreciated.
I know a lot of folks who are happy with the products from Synology. I haven't used them first hand as I've got a decent investment in Drobo gear, but the Drobo stuff skews to the expensive side of things.
Ok my excel gurus. I feel like this should be easy but am confounded and not sure how to word my search:
I have a list of names and dates, a column for each. Like Smith 1/31/21 and Smith 3/1/21 and Jones 2/14/21
I want a list of the most recent dates.
Smith 3/1/21 Jones 2/14/21
Or even better, the most recent and the previous, in columns
Smith 3/1/21 1/31/21 Jones 2/14/21
What do I do to get this? So far I made a pivot table separating out dates before and after now, with min or max, so I’ve got two tables one that lists max before today (most recent) and one that lists min date after today (next) but feel like there must be a better way to do this
I want a list of the most recent datesMaybe use the Sort command on the dates column, high-to-low and note the results you were looking for, and then re-do the Sort as low-to-high?
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
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.
Thanks t, I’ll give it a shot!
Are Duck Donuts a thing anywhere else? The business model is a doughnut topped with stuff, like bacon. link
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.
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.
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.