Re: Count unique records?

In article <C06811E4.CC82F%berkowit@xxxxxxxxxxxxxxxx>,
Paul Berkowitz <berkowit@xxxxxxxxxxxxxxxx> wrote:

I'm still not understanding why blank is not a valid value, I guess. Is that
the operation can't be performed at all with a blank cell, so 0 is returned
by default?

Almost. A reference to a cell always returns a value. If the cell is
blank, the reference returns either numeric zero, or a null string,
depending on the data type that's expected. A zero is returned by
default.

COUNTIF(), however, appears to coerce both the range values and the
target value to a string.

Without the &"", the returned value is coerced to "0". This will not
match the blank's null string.

By concatenating the returned reference, the returned value is coerced
into a null string, and the result of the concatenation is also a null
string. This *does* match the blank cell's value in the range argument.
.

Relevant Pages

  • Re: Concatenating a range of cells from another sheet, possible?
    ... CONCANTENATE connects several strings, ... Not a cell/range reference!). ... returns a string "Sheet1!A1", not a reference to cell Sheet1!A1, etc. ... conbination of CONCATENATE, INDIRECT, and ROW (which was the solution ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Cant get text of e.Item.Cells(x)
    ... > I cannot grab the text of a datagrid row's cell. ... I tried to reference that cell ... > Dim TestStockNumber As String = CellControl.NavigateUrl ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: show cell reference as text
    ... Function wsAs String ... How to show a cell reference as Text: ... Should read G12 ...
    (microsoft.public.excel.programming)
  • Re: Concatenate multiple rows and columns into 1 cell
    ... >I have a spreadsheet using 3 columns and n number of rows worth of data. ... >am trying to create one long string of this data by concatenating in the ... >cell and that will take a very long time. ...
    (microsoft.public.excel.misc)
  • RE: Last modified date of a linked file
    ... Thanks Joel. ... I haven't figured out how to convert an active cell reference ... is there a way to use a cell reference that would be ... updated when along with other links in the worksheet instead of the string ...
    (microsoft.public.excel.misc)