=TEXTJOIN(",",TRUE,IF($D$2:$I$87=M2,$A$2:$A$87,"")) The information being pulled is Dates, unfortunately it keeps pulling the dates as Numbers , I have tried the Text and “dd/mm/yyyy” but im not sure where to put it into the formula, ive tried a couple of locations , but i just get you have entered too many […]
Monthly Archives: April 2025
67 posts
I have an ASUS RT-AX58U configured with two VPN Fusion servers, one that routes to a VPN, and the default which routes directly to the provider’s Internet service. I also have a guest network configured on the router so that there are two ssids. Is there a way to route […]
I am trying to build an aarch64 cross compiler for my Ubuntu 20.04 system. I am running into an issue after configuring and trying to build the toolchain. The source I am using is https://ftp.gnu.org/gnu/gcc/gcc-11.2.0/gcc-11.2.0.tar.xz ./configure --target=aarch64-linux-gnu --prefix=/usr/local make -j4 Normally when there is some unmet dependency it is obvious […]
Hi does anyone know how Magento advanced reporting works out the revenue on the advanced analytics reports? their results is very different to what I have. I have tried to calculate net and gross revenue via the data which comes from report > sales> orders and show actual values. when […]
i have written one aja in jQuery , which is folowing settings = $.extend({ method: 'GET', url: decodedUrl, dataType: 'json', cache: false, contentType: 'application/json', data: { aln: '✓' }, showLoader: true, pushState: pushState }, settings); //onDone = onDone || this.onDone; $.ajax(settings).done(function (response) { console.log('response : ', response); }).fail(function (jqXHR, textStatus, […]
I would like to know if there is way to get the originating address details of a Sales Order in Magento (Adobe Commerce). The order API response does not seem to have that detail but it has billing address and shipping address.
I am trying to add the MassAction in listing of Credit Events but get an error as “This tab contains invalid data. Please resolve this before saving.“ This error comes when I am trying to create a New Company but when I edit the company this error doesn’t come. Screenshot […]
I don’t want to remove Nilesoft Shell as I find it very useful, but I need to be able to open files with Notepad++ from the context menu. Has anyone encountered this specific conflict between Nilesoft Shell and Notepad++, and found a solution?
I received a notice from Verizon stating that my Actiontec router needed to be replaced. It said that my old router would still run OK past its obsolescence date, but that if I chose to keep it, they would no longer provide support for it. I agree that I should […]