Last seen: Aug 23, 2025
Yep, that's done. Job accomplished. Very satisfying.
I tried that but it produced VALUE errors all over the place. I think I prefer to leave it as it is for now.Off to play golf now, you have a good day ...
Sadly I cant use that, my version of Microsoft Office LTSC Professional Plus 2021 doesn't have those functions. Like I said, its not a problem though....
Okay, I think I've done it now. The attached file is the Master sheet ready for the next competition and using your formula. I don't know why BI is sh...
Ah, solved one part. No longer need the helper column. Changed your formula to=LET(hcp,IF((A4:A85=1)*(BH4:BH85=0)*(AQ4:AQ85<=BG3),D4:D85,""),tot,SU...
I've twigged that now but struggling. Works fine on the worksheet posted on here but can't get it to work on the Master sheet. I keep trying. Problem ...
Been unable to copy this over to my Master sheet, keep getting a spill error and I don't know why.
So I had to change your formula so that if there was also an increase in BH that didn't involve those finishing 1st, 2nd or 3rd, it would stop that pl...
First off, thank you so much for taking an interest, I'm always looking at ways to improve this workbook. I'm no expert at Excel so quite a lot of my ...
Thank you so much, I was beginning to think it was an impossible task.
Thank you. At first inspection that seems to work perfectly, exactly what I want. The first row didn't work but I just added an extra row at the top w...
I've got so far but have again come up against a brick wall. In the example workbook sheet 2 works okay until you add a row/transaction, then the form...
I basically started again, got rid of the table, then created another. It works now (sort of) but it always seems with excel that when you resolve one...
I'm all good now. Thank you.
