In Excel, filtering a dynamic array is simple. Something like this: =FILTER(my_array,IF(condition,filter1,filter2)) But what do I use if filter2 (say) is simply the TRUE condition; i.e. if condition is false I just want to reproduce my_array without any filtering. This doesn’t work: =FILTER(my_array,IF(condition,filter1,TRUE)) presumably because the filters need to be […]
Rubin
14259 posts
Having two internet connections at home, I bought this switch to choose which network to use: The problem is, like flipping the switch, the Arch doesn’t notice the network change and hangs until I reset it with: nmcli con down 'Network 1' nmcli con up 'Network 1' How can I […]
Looking for newer easier solution than found here: How to count pages in multiple PDF files? or at least explanation on how to download and install cygwin
I tried to set up Ubuntu Server v.23.04 guest machine for SSH remote access in my virtual environment using Virtual Box v. 7.0 hosted on macOS Monterey 12.6.5 . To my surprise I receive some errors. Below I paste error. Kernel panic - not syncing: no working init found. Try […]
I bought a wireless network adapter so I put it in my Windows PC, I installed the driver automatically by an .exe program that installed in it; then I installed Kali Linux (last version) to start practice some programming codes in Kali Linux software (installed by Oracle VM Virtual Box), […]
I have setup a zimbra server on an ubuntu VM, opened up the necessary ports according to this tutorial. I am able to receive emails from gmail or outlook using other email domains. However, no emails are received when I sign-up for services that send confirmation emails or alerts. For […]
I am trying to capture my windows10 desktop with desktop duplication api and on-gpu D3D11 textures, in the form of ffmpeg D3D11VA frames @60 fps. Required command is given here. On top of that I am trying to also intercept my mic audio and Desktop audio. For that I am […]
I’ve tried the following to disable this behaviour: System Preferences -> CDs & DVDs -> When you insert a video DVD: set to Ignore (actually moved all of them to Ignore) Neither of these made a difference; insert the disc and the DVD player still starts playing it. Any other […]
In several scenarios, when I click on a link in the browser, the new page doesn’t load but instead the tab for the link on the top left begins flickering. Sometimes it will effectively reboot the browser, sometimes it will just hang things. I have roughly the same problem with […]