I have a fairly convoluted formula but for the problem at hand, it really only concerns the 2nd If statement. =IF(OR($H24="",I$18=""),"",IF(I$18="Additional Notes",IF(ISERROR(MATCH($H24,AdditionalNotes!$H$16:$H445,0)),"", HYPERLINK("#AdditionalNotes!I"&MATCH($H24,AdditionalNotes!$H:$H,0),"Additional Notes")), IF(INDEX(MasterSheet!$B$4:$AG$500,MATCH($H24,MasterSheet!$D$4:$D$500,0), MATCH(I$18,MasterSheet!$B$4:$CF$4,0))=0,"",INDEX(MasterSheet!$B$4:$AG$500, MATCH($H24,MasterSheet!$D$4:$D$500,0), MATCH(I$18,MasterSheet!$B$4:$CF$4,0))))) Basically, if a column contains “Additional notes”, it’ll search a sheet called AdditionalNotes for a name. If that name exists, then I […]
Rubin
14236 posts
I want to use proxy only for one website URL, and if the proxy is disabled or down, the URL blocked by a firewall So in my mac os, I connect to a proxy server somewhere, and then if I open, for example, google.com, all the traffic pass from the […]
I made a batch-file snake game and inserted some special characters via HEX to ANSI conversion in Notepad++. It worked normally. But I noticed that there was an update to the Consolas font and two of the characters became visually the same. Are they: One of them was slightly larger. […]
VS Pro 2019 Version 16.11.5 Resharper Ultimate 2020.1.4 In VS2017, with an earlier version of Resharper, I would see two sets of context menu options for debugging/running tests when I right click on a test class or test method. One Run/Debug set was to run the test(s) using VS test […]
There is a surveillance system with one sata input, there are several hard drives that I would like to connect through this port with that sata hub After a careful reading I came to the conclusion that this connection requires a pci-e raid controller, but there is no pci-e on […]
My aim is convert decimal number to binary numbers and putting binary numbers one by one per column in EXCEL. I did convert decimal to binary using BASE command and do not know how to put it one by one in columns. Here is the picture that I want to […]
So I followed this guide for installing arch. This is my first experience with Linux so I don’t know what’s happening and following along as best as I can. After a reboot stage tho at around 20:40 I decided to stop the whole process because grub wasn’t showing windows or […]
Excel allows to combine formatting with TEXT(), e.g.: =TEXT(B2, "ddd") =A2&" " &TEXT(B2,"mm/dd/yyyy") But if I try to do this on office365 it just display that text (does not work). What’s wrong? UPDATE: B2 contains 01.01.2022 formatted with d.m. thus displayed as 1.1. (my locale setup). But just direct formatting […]
I think most of the household internet uses the NAT network. That is within the household, every device is having a unique private IPv4. Then many households are sharing one public IPv4. Suppose I set up a web server on local port 80 and then set the port forward from […]