Time4Red

I have a long list of last names in sheet 2 column C, and I'm trying to make a formula which counts the number of times each name appears in column B of sheet 1, and copy that formula down column D in sheet 2. My initial thought was to use INDIRECT. So in D2, I put:

=COUNTIF(Sheet1!B:B,(INDIRECT("C2")))

But INDIRECT specifically removes the reference information when I copy the formula down the row. In other words, when I copy to D3, I get:

=COUNTIF(Sheet1!B:B,(INDIRECT("C2")))

instead of

=COUNTIF(Sheet1!B:B,(INDIRECT("C3")))

Any suggestions?

I've been having a problem where plugging in any USB peripherals prevents booting or getting into the BIOS. So I tried the boot into windows recovery then boot directly into UEFI settings hack. No dice. It just freezes at the splash screen before the bios.

I can boot into windows fine as long as I unplug everything, but I can't get into the bios at all, so I can't check BIOS settings or flash an update. I feel like my only option left is a CMOS removal? If that doesn't work, what then? Is my mobo just soft-bricked? It's only 5 years old.

Republicans in the senate and the Biden administration as reached a rough deal on comprehensive immigration reform that has been deemed a huge conservative win. The deal dramatically strengthens border security without any path to citizenship in exchange for continued aid to Ukraine.

The emerging Senate package is expected to raise the bar for asylum-seekers to come to the U.S., grant additional powers to remove migrants to control the border and restrict the use of parole to admit certain migrants as they await processing for their cases.

Some House Republicans have signaled a refusal to negotiate or commit to any votes. Some have even threatened to vacate the speaker if he allows a vote