ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
very good, thank you
No problem. Thanks for the comment. How often do you use excel?
@@datauntelligence very often, but I have an older version which does not support "unique".
Ah yes, Excel seems to update often. It's hard to keep up with what's new.
Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")
I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.
Let me guess...you've been trying python in excel
Yeah, python in excel is a good addition. Have you tried it? What do you think?
@@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to
very good, thank you
No problem. Thanks for the comment. How often do you use excel?
@@datauntelligence very often, but I have an older version which does not support "unique".
Ah yes, Excel seems to update often. It's hard to keep up with what's new.
Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")
I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.
Let me guess...you've been trying python in excel
Yeah, python in excel is a good addition. Have you tried it? What do you think?
@@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to