just had a 5 minute chat with ChatGPT to get it to trial a bunch of google sheets formulas to get the result I desired. it got it wrong the first couple of times but when I asked it to consider another way, it nailed it. truly amazing.