Tag: Reference

I have a sheet where pairs of columns are logically grouped, such that $B:$B contains a list of names, and $C:$X are the logical pairs ($C:$D, $E:$F,...). There is also a header row $1:$1, where the paired columns are each merged for display purposes ($C$1:$D$1, $E$1:$F$1,...) I have a number of conditional format rules which apply to the pairs, but only to the intersection of non-header rows (currently fixed at $2:$5000, which is more than enough for now) and to either the first column of each ($C:$C,$E:$E,...) or to the second column of each ($D:$D, $F:$F,...). These get automatically expanded by the Conditional Format dialog, so they appear to apply to =$C$2:$C$5000,$E$2:$E$5000,$G$2:$G$5000,... or =$D$2:$D$5000,$F$2:$F$5000,$H$2:$H$5000,... Over time, as users of the

I am trying to call a batch file from another batch file and pass an argument containing a caret ^. Here's a minimal example: @REM @echo off call composer.bat require "psr/log:^3.0" However, the call command is escaping the caret which is causing the command to fail: In VersionParser.php line 526: Could not parse version constraint ^^3.0: Invalid version string "^^3.0" I tried removing the double quotes from psr/log:^3.0, but this is causing the caret to be removed entirely. How do I prevent call from doubling the caret?

I have a table that could have any number of "Regions", almost in any order. I'm wondering if there's a way to use some sort of "lookup table" that looks to a region, then fills the cells with a color. Example data: Name Region Value Chuck East 213 Josh East 321 Jeri North 1232 Noel South 329 My idea is to use a table like below, so anytime a region is matched, the cells in the table above are filled with that color: Region HEX Color East #87F1A8 North #8962D8 South #D49362 The idea is I can easily/quickly change a fill color, add/remove regions to fill, etc. without having to go in to the Conditional Formatting thing and manually do so. If I had only three regions, I can make those manually, but if I have over 20+ regions, I'd love to not have to make 20 separate entries, and update them all when wanted. (So in my data table, all the rows with E

The memory card was placed in the smart phone when I put it back in a button phone it could show some files with name containing numbers which is like foreign language and if I could try to open it could show me unrecognized file name but when I tried to format it using a computer it stopped from being detected.

I recently experienced a tremendous slowdown while using Microsoft Outlook 2019, but this problem could occur with other versions. This slowdown manifested as a 45 second delay before the app responded to even a single click. I tried all the forum posted recommendations I could find. The particular post at this URL provides most of what I could find, but none of these solutions worked.

I recently bought a brand new Crucial P310 2230 M.2 NVMe SSD in 1TB size. The box says 1TB and the stickers on the drive say 1TB. The box was sealed and the drive looks high quality and genuine. I've not heard of fake 2230 SSDs. However, when I look at the drive in disk management, it shows as 2TB: What's going on here?

I had a problem with one of my applications. I needed to use and focus on a series of updates in October, which could make a difference for this app (well, the problem lay elsewhere, and I already solved that one). I have started uninstalling the following updates till I get to KB5066791 (the cumulative update before ESU). I uninstalled this one; Windows didn't give me any error in feedback, but after a restart, this update was still on the list of installed ones (updates were suspended, so Windows has no possibility to reinstall it by itself). I have a button to uninstall KB5066791, but I can't do it anymore due to an error. So i thought to reinstall the update (to be sure it is properly installed) but do not know how to achieve it. I got an update in the MSU file from the Microsoft catalog website. Running MSU gives me an error that the update is already installed. Running MSU with DISM ends at 5%. Is there a way to force MSU to fully reinstall? KB5066791 has been su

Using Acronis True Image for more than 20 years now, I think I'll finally quit using it, because the company just doesn't fix well-known bugs, while the base system is highly unreliable. Read this story: On my laptop I configured Intel VMD RAID1 on two SSDs and installed Windows 11 there. That was kind of tricky, especially as (end of last year) the Windows 11 installation medium lacked the drivers needed for a VMD installation ("no disks found"). The Linux based boot medium of Acronis cannot handle the VMD, even if the Linux MD-driver can! Acronis support knows that for at least five years (maybe even 10), and their business product can handle that (Acronis support also knows) In the course of getting Windows installed (actually I tried restoring a Acronis True Image backup (using Acronis Universal Restore) I had made when there was a non-RAID configuration of Windows) I installed more than one Windows in different partitions until I was happy with th

I have a Windows installation on a drive that I cannot/should not boot: I only have the disk attached to some WinPE / Linux live USB. I want to know whether Intel VMD was enabled in the firmware at the time that particular Windows was installed. What offline evidence can I look for on the Windows partition to determine whether VMD was enabled during installation? Where would Windows put traces that indicate the VMD driver/hardware was present at setup time?

Which Chrome directories can be safely removed to clean up the storage? In particular, what do shared_proto_db and File System do?