Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one row cell only in a cell range
I want to be able to enter data (whole number) in only one row cell from a
range of cell. An error message would show if data is entered in an other cell in that range. I am desperate to get an answer. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one row cell only in a cell range
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one row cell only in a cell range
I have been working on your response for the past hour with no result.
Refrased question: In a selected range of cell (7 cells) in one row I want to enter a number in only one of those cell which will correspond to information in the column header. If data is entered in an other cell in the same range this needs to create an error. Thanks Serge "vezerid" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting data top 1st empty cell in range | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
Data range reference in a cell | Charts and Charting in Excel | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) |