| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change a blank ("") value to a cell with no value?
I am trying to perform Descriptive Statistics in Excel using columns that
contain blank values resulting from a boolean statement that returns "" if false. Excel will not allow me to run Descriptive Statistics beacuse the blanks are non-numeric values. Is there any way to give these cells no value? Replacing the blanks with zero is an option I prefer to avoid. Thanks! |
|
#2
|
|||
|
|||
|
Try filtering for "", then selecting the returned subset and clearing
their contents. HTH, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
| Cell references change when entering new data | New Users to Excel | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
