Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Bugs
Excel is counting incorrectly, I think. I am using counta to count
the number of Xs in a column. If I enter counta(a1:a23,"x") it evaluates to 1, which is incorrect. If I enter counta(a1:a23) it evaluates to zero, which is correct. To verify this I search/find a1 to a23 for x, it says there aren't any. I also visually inspect the column and there are no Xs. It does this in a number of columns. It also miscounts 1 X as 2 Xs. When there is more than 1 X in a column, it appears to count correctly. My spreadsheets aren't that big, less than a MB each. This is not the first problem I have encountered. When I copy then past special-- values only and transpose, it sticks in extra cells containing zeros. I get a lot of buggy stuff like this. Why do I not see other people complaining about things like this? I am a fairly sophisticated computer user. Can anyone tell me if I am doing something wrong. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink bugs | Excel Discussion (Misc queries) | |||
Two Bugs in Excel 2003 With Hyperlinks to Files | Excel Discussion (Misc queries) | |||
Excel 2007 Beta - 30 bugs | Excel Discussion (Misc queries) | |||
Fixing some bugs | Excel Worksheet Functions | |||
excel bugs | Excel Discussion (Misc queries) |