View Single Post
 
Old 11-24-2024, 06:14 AM
ToLoC999 ToLoC999 is offline Windows 11 Office 2019
Novice
 
Join Date: Nov 2024
Posts: 3
ToLoC999 is on a distinguished road
Default

Hiya Pecoflyer,

Whatever I tried I could not get the syntax correct for a INDIRECT statement and therefore came up with a cunning workaround.

I created another formula in the worksheets (B13) that had the formula =IF(B3>0,1). Refer to the attached screenshot but this basically changed its value from FALSE to 1 as soon as the first score went in. From here I was able to write into the formulas to only include the worksheet if B13 = 1
Attached Images
File Type: png Screenshot 2024-11-24 131204.png (17.3 KB, 22 views)
Reply With Quote