Daily Archives: February 9, 2024

I’m struggling to get my son’s PC working again. The motherboard is a Gigabyte H410M H V2 (rev 1.7). Okay, so a new GPU required a new PSU which required a new motherboard which required a new casing, so yeah, not feeling brilliant. Triple-checked cabled which seems correct but no […]

=SUM(–(FREQUENCY(IF((indirect(E9))$B$9:$B$2061=C2,MATCH(Table1[PO’#],Table1[PO’#],0)),ROW(Table1[PO’#])-ROW(‘2023’!$G$9)+1)>0)) In the above formula i and trying to make the sheet ‘2023’! an input from a different cell.