Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blanks counted when highlighting group of cells
When I highlight a group of cells that include values and blanks, the "count"
function that shows up at the bottom of the screen counts the blanks as well as the values. I know if I use "text to cloumns" on the column, it will clear out the blanks, but is there a faster way? I have alot of columns and I'd hate to have to do "text to column" on each one. I only want to count the values in each column. -- mm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How do you add a group of cells by highlighting them? | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions |