for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

run free May 2023 11:28am, 19 May 2023 5,294 posts	Quote Pin run free They may not come up with the process. The courses they attend will help direct them to come up with a process. A good consultant will enable them to create the right processes
run free May 2023 11:33am, 19 May 2023 5,295 posts	Quote Pin run free Anyway AI will take over those types of jobs...
GlennR May 2023 2:08pm, 19 May 2023 70,339 posts	Quote Pin GlennR I can't find AI slow-witted enough.
run free May 2023 6:45pm, 19 May 2023 5,296 posts	Quote Pin run free ChatGPT integrates with Excel and is learning
SPR May 2023 1:28pm, 30 May 2023 40,727 posts	Quote Pin SPR Just used, Unique and Filter for the first time, in conjunction with COUNTA to get a unique count with criteria. Certainly makes unique counts easier than they used to be.
SPR May 2023 1:56pm, 30 May 2023 40,728 posts	Quote Pin SPR Flaw there as an error counts as 1 but I was able to switch to Count to sort that.
GregP May 2023 2:04pm, 30 May 2023 145,967 posts	Quote Pin GregP ChatGPT is more useful than google half the time.
Bowman 🇸🇪 May 2023 3:15pm, 30 May 2023 2,735 posts	Quote Pin Bowman 🇸🇪 I use GPT all the time for formulas, dax, m-language and so on Sometimes you have to chat a bit and explain some more, but very useful for sure
run free May 2023 10:08pm, 30 May 2023 5,297 posts	Quote Pin run free COUNTA counts non-blank cells. So counted correctly. Anyhow good catch and fix
SPR May 2023 10:19pm, 30 May 2023 40,731 posts	Quote Pin SPR I know COUNTA counts non-blank cells. What I didn't expect was Unique with Filter to error when it found nothing. I suppose it makes sense as the formula has to produce something but I hadn't thought that it would initially. At some point, I'll potentially need to come up with a way for it to work with a COUNTA type formula or switch to old style frequency formulas. Not ATM though.