I need help making my excel cell display as either DATE (10/11/12) or NUMBER (1234) format depending on my cell reference (vlookup). Formatting cell as NUMBER, DATE or GENERAL cannot work because it will fixed number to date format or date to number format. Example: when search “City Hall”, column […]
Blog
23415 posts
(This is a bit of a Big Wall Of Text; my actual questions are boldfaced, but unfortunately the surrounding text is probably needed to make sense of them.) I am running WSL2 under Windows 11. (WSL version 2.0.0.0, WSLg version 1.0.57, Ubuntu 20.04.6 LTS installed IIRC via the Microsoft Store.) […]
I’ve set up AdGuard on a Raspberry Pi in Home Assistant and I’ve configured my router to use it as the primary DNS. However, the Raspberry Pi occasionally stops so I’ve set a secondary DNS in my router to 1.1.1.1 as a backup. But this means that as AdGuard doesn’t […]
Is there a practical way to do this: Clone SSD A to SSD B of the same size. Boot from SSD B, but retain SSD A in the system. Set up scheduled incremental backup so that periodically SSD A should be made identical to SSD B. (Not sure if this […]
I’d like to add 8TB DELL Exos 7E8 drives, model ST8000NM0185, to my servers. I bought these SAS->SATA adapters to connect them, but the drives aren’t detected by the BIOS. I mainly use ASUS motherboards. Do I need to enable any special options for them to be detected by the […]
Handling a large product catalogue in Magento 2 can be a real headache. While Magento is powerful and highly adaptable, managing tens or… Continue reading on Medium »
How to block specific email address? The customer is registered as guest but making series of suspected fraudulent transactions. We see he is using different credit cards, fictitious address and different IP address. The only info he doesn’t change are his name and email address.
I have added an ajax pagination in a custom module collection. I have a total of 50 items in the collection and the limit per page is 5; that should show total page of 10. Instead, it is showing only 5 pages, it is not showing the next page Link […]