Forum Discussion
COUNTA and ISBLANK
Have the data been imported/copied from a source outside Excel? The blank-looking cells are not really blank.
One workaround is to use
=COUNTIF(Table3_1[@[Text Between Delimiters.5]:[Text Between Delimiters.11]], "> ")
Another is to select the entire table except for the last column, then activate the Visual Basic Editor (Alt+F11), activate the Immediate window (Ctrl+G), type
Selection.Value = Selection.Value
and press Enter. The COUNTA formula will then work correctly.
Have the data been imported/copied from a source outside Excel? The blank-looking cells are not really blank.
One workaround is to use
=COUNTIF(Table3_1[@[Text Between Delimiters.5]:[Text Between Delimiters.11]], "> ")
Another is to select the entire table except for the last column, then activate the Visual Basic Editor (Alt+F11), activate the Immediate window (Ctrl+G), type
Selection.Value = Selection.Value
and press Enter. The COUNTA formula will then work correctly.
Thanks HansVogelaar , yes the data is imported from a txt file into excel, using PQ, Could you please educate me on your formula:-
=COUNTIF(Table3_1[@[Text Between Delimiters.5]:[Text Between Delimiters.11]], "> ")
What does this parameter "> " does ?
Thanks in Advance,
Br,
Anupam
anupambit1797 It counts values that are "larger" (alphabetically) than a space " ". A space is the first ordinary character in the sort order.
Thank you so muchHansVogelaar , earlier I studied # and $, but this "> " was new for me.. sorry for my short skill on Excel, but what we call such special "> " functions in excel, is there any link say where I can find the list of all such special functions using these > ,< #,$ etc.. with their definition( like what they do; can be used to do?)
Br,
Anupam
