Re: How to enter data in one row cell only in a cell range

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Serge,
the following *array* formula (needs to be entered with
Shift+Ctrl+Enter) will test if there are more than one numbers in
A1:A100
=IF(SUM(--ISNUMBER(A1:A10))>1, "One too many", "")

To test if you have more than one non-blank cells in the range (incl.
text), use:
=IF(SUM((1-ISBLANK(A1:B20)))>1, "One too many", "")

HTH
Kostis Vezerides

.

Relevant Pages

  • Re: [PATCH linux-cr] nested pid namespaces (v2)
    ... Serge E. Hallyn wrote: ... we keep the original single pids_array to minimize memory ... The pids array entries are augmented with a pidns depth ...
    (Linux-Kernel)
  • Re: Looking for speed performance to draw line.
    ... each item in an array, that being the next and/or previous indexes. ... and it's next pointer to the previous item's original next pointer. ... Next -1, Prev 0 ... shapes up into shape classes that implemented the required commands ...
    (microsoft.public.vb.winapi.graphics)
  • Re: Multiple Condition Sumif Formula
    ... Andy. ... > revenue column. ... > & I've tried to enter the formula as an array by doing ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Subtotal variable range
    ... You have several ways, here is one, which is an *array* formula ... (commit with Shift+Ctrl+Enter) ... Kostis Vezerides ... On May 20, 8:58 pm, JDaywalt ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Row Compression
    ... Otherwise, use Jim's suggestion ... > And want to remove rows with a blank in column 1 and collapse the whole ... > array to get: ... Prev by Date: ...
    (microsoft.public.excel.misc)