I’ll try to keep this short because my actions rather than the circumstances is kind of my point. Using AI to help solve Excel formula issues has become somewhat of a crutch for me. I describe the behavior I’m looking for, or trying to stop, and then copy/paste the revised formula and test. Recently had a formula combing a table and returning a sorted unique list based on criteria. I noticed that when it was looking for a value that wasn’t 0 (<>o), I got a result that appeared correct, but when looking for results that were (>5), got a bad results. Specifically, it omitted expected results. I’ve gotten good results in the past with AI so I spent additional time working through prompts thinking I wasn’t explaining the problem. Turns out somehow I ended up with hidden rows on the sheet and the missing “expected content” ended in these hidden rows. The explanations that AI generated for this missing content could have sent me spinning for god knows how long. Classic “Garbage In, Garbage out”, but in this case AI rebranded my garbage as good, and built on it. I hope companies jump on this AI replacing jobs thing and drive right off that cliff. Sort of a Darwin project to weed out weak-minded organizations and decision-makers. submitted by /u/mghal9000
Originally posted by u/mghal9000 on r/ArtificialInteligence