Rubin

Excel data Hi – I need assistance creating a formula with match statement(s). My current formula isn’t reading all my columns and gives me an “N/A” the moment I change “FOB” <–column I am referring to. Heres my current formula – =VLOOKUP(XLOOKUP(VALUE($A16),VALUE(FOB!$A:$A),FOB!$D:$D,,0),$U$5:$AB$13,MATCH($G$5,$U$5:$AB$5,0))*$O16 Which works, because I want the total to […]

in windows dhcp server if i set hte lease time to unlimited or any duration the ip address per mac is always the same .. (dhcp static) i guess How do i do that in linux? its really anonying if someone reboots an android devices reconencts and ihave to find […]

I do not know much about this topic so any help would be appreciated. I live in university residences and the internet connection that is provided to us is hosted by Wifinity networks. I run a media server from my residences that hosts a webui that I would like to […]

Grub not showing support for all possible video modes? (Using Debian 12) Grub only shows support for 1280×1024 maximum, but once GNOME is up, 1920×1080@60 shown per the XWAYLAND0 device. Why this difference? How can are get grub to show parity to what the GNOME UI supports?

I want to connect my desktop computer to the TV through a hole in the wall which should be as small as possible. The two devices are only couple of centimeters away from each other, so cable length should not matter. My first idea was to connect the PC via […]

I dual booted fedora 39 with windows 11 the boot logo (vendor logo lenovo) during windows boot is black just the loading circle is there. But when i boot to fedora or screen before grub the logo is there Is there any way it could be fixed

I’m very new to VBA coding (only dabbling for this specific project), so I would really appreciate any advice on an issue I’m having. I’m attempting to independently link multiple column ranges on Sheet1 (e.g., A2:A300, B2:B300) to various different column ranges on Sheet2, Sheet3, etc. This way, changing any […]

I have erroneously deleted a LVM Thinpool by deleting a VM in Proxmox. I need to recover the data from this Thinpool and I’m struggling on getting in up again. LVS tells me: LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert SAS_ARRAY_0 SAS_ARRAY_0 twi—tz– <3.61t [SAS_ARRAY_0_tdata] […]

enter image description here Image for explanation. I used the =days(end,begin) formula to calculate the number of days that has lapsed since servicing. HOW DO I HIDE THE 45396 number?????? Super beginner to excel, just learning formulas.