What function can I use to find the first non-blank cell from the bottom up in a column and display that value in the bottom row?
Yearly Archives: 2026
There is a notebook DELL G3 3779 with internal SSD/SATA/GPT/UEFI on motherboard (m.b.) – it is bootable disk with Windows 11, and HDD/SATA on m.b. (GPT too) The notebook must support NVME. OS – Windows 11, mode – UEFI, Fastboot option – Thorough I have upgraded SSD/SATA to a new […]
These lines appear sometimes when I turn on my PC, I cant replicate it constantly enough to understand what the issue is and I cant wrap my head around it. This bug also affects the monitor OSD but it never happens on Windows. It sometimes appears when I idle too […]
I want to copy the cells format/color to other tabs. I am using =A1 to pull the cell into other tabs. Tab 1 is my master list. I have 11 additional tabs. On Tab 1, each cell is named. On Tab 2 – 12, I reference the cell name on […]
Ethernet was working normally until i used a USB wifi adapter and didnt connect to any networks, unplugged it after a few minutes. when i unplugged the adapter it the network status says connected with “no internet” despite the internet working fine on other devices. (“Your device is connected and […]
When installing a network printer on a Windows 11 PC (the printer is shared on a Windows 10 PC on my LAN), I get a two login prompts. On the first login, when I connect to the remote computer it works fine with .admin as user name: However, the second […]
We’re upgrading a staging environment to Magento 2.4.8-p5. Looking at app/etc/di.xml, the SqlVersionProvider supported-version patterns now look like this: So here in the app/etc/di.xml they have mentioned mariadb 10.2-10.6, but on the official documentation System requirements, they mentioned MariaDB 11.4,11.8. On my staging site environment mariadb 10.5 is supported, so […]
So I’m planning a general-purpose PC build that will use a few old SATA HDDs I have. The case holds three 3.5” and three 2.5” drives. I’ll be using an Ubuntu LTS, as it’s what I’m used to, and I’m thinking that I’ll place that on an M.2 SSD. (I’m […]