Forum Discussion
=COUNTA Not Working
Hello,
it is still problem and your solution is not related to maybe bug.
When I am using something like this:
=UNIQUE( FILTER( table[Column 1], (table[Column 1]<>"List") ) )
it properly display entries from my table different than List in Column 1.
After cover it with IFERROR to show me just "" if nothing exist we have:
=IFERROR( UNIQUE( FILTER( table[Column 1], (table[Column 1]<>"List") ) ), "" )
My table don't have anything so result is ""
Now, I pot it inside COUNTA as below:
=COUNTA( IFERROR( UNIQUE( FILTER( table[Column 1], (table[Column 1]<>"List") ) ), "" ) )
and result is always 1, because for COUNTA("") it is always 1... no sense 😞
Can we fix it or maybe another way?
I know maybe my example is little bit complicated and there is simple way to count elements in range, table or any. Can you help please?
In this moment I just going around and checking IF first cell in Column 1 is empty, if it is return 0 if not - formula above 😞
Try this:
=LET(f, FILTER(table[Column 1], (table[Column 1]<>"List", ""), IF(f="", 0, COUNTA(UNIQUE(f))))Hello Hans
thank you for it, little similar to my work around 😞
So sad Micro$oft never doing thing professional, also in Excel.It is so sad they never update this software and improve after users suggestions and many many posts in this area. Google sheets going to be much better and maybe someday Google release offical app as Excel. I am sure world switch into it. Online documents is not good for confidential solution, but maybe someday powerful Google make a good thing.
As a comment, COUNTA() counts cells/array elements with any kind of information, includes error. That's in Excel, Google Sheets and other spreadsheet software.
Hello,
I found out what is a problem. Sorry I am right it is related to typical bug in WIndows, not directly to Excel. After reinstalation everything with amateur system windows included it back to norm. Before it appeared with side effect where excel generate unknown sheet, impossible to remove, visible only in VBA editor and always crashing excel after few tries to save it. Unfortunately xlsm file in real is a zip file and after too many operation, primitive non-professional, not operating system in mistake of humanity cannot handle it and file is incorectly saved = lost! Thanks to Micro$oft for not professionalism, not responsibility and cheating peoples around the World. Very big thanks to Polish group which expose the problem almost 10 years ago and it wasn't fixed by sorry "idiots" in this fake company up to today. I lost a lot of data and work beacause of this problem. Our teams starting to make full documentation about problem and risk to work with Micro$oft software and need re remove it from company fast! And Micro$oft is asking to pay any money for this beta crap software? Is it a joke?!?!? For beta testing they should pay us!
