| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
data in cells
I want to look through a range of cells (A1:z1) and if any one of the cells
is not blank I would like to return a 1. Thanks Ron |
|
#2
|
|||
|
|||
|
Hi,
How about ... =IF(COUNTBLANK(A1:Z1),1,0) -- Regards, Zack Barresse, aka firefytr "Ron" wrote in message ... I want to look through a range of cells (A1:z1) and if any one of the cells is not blank I would like to return a 1. Thanks Ron |
|
#3
|
|||
|
|||
|
Your formula returns a value if any one cell is blank, I need it to return a
vlaue is any on cell is not blank. "zackb" wrote: Hi, How about ... =IF(COUNTBLANK(A1:Z1),1,0) -- Regards, Zack Barresse, aka firefytr "Ron" wrote in message ... I want to look through a range of cells (A1:z1) and if any one of the cells is not blank I would like to return a 1. Thanks Ron |
|
#4
|
|||
|
|||
|
Oh, my apologies. Maybe you can try this then ...
=IF(COUNTA(A1:Z1),1,0) -- Regards, Zack Barresse, aka firefytr "Ron" wrote in message ... Your formula returns a value if any one cell is blank, I need it to return a vlaue is any on cell is not blank. "zackb" wrote: Hi, How about ... =IF(COUNTBLANK(A1:Z1),1,0) -- Regards, Zack Barresse, aka firefytr "Ron" wrote in message ... I want to look through a range of cells (A1:z1) and if any one of the cells is not blank I would like to return a 1. Thanks Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate empty cells in data range | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
| Averaging only cells with data | Excel Discussion (Misc queries) | |||
| cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions | |||
Linear Mode
