| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count rows with data
On Fri, 31 Mar 2006 14:30:02 -0800, Bryan Brassell
wrote: Need to count the number of rows that contain data - ignoring formats. How are you defining data? Is that any piece of information, i.e. text, formula or number. Does just one occurence of a piece of data in a row mean that you count the row, or does every row have to contain data in every cell in a range of columns before you count the row? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
count rows with data
any data, formulas, numbers, text, etc. One occurence in the row does count.
-- Regards, Bryan Brassell Padgett Business Services 281-897-9141 "Richard Buttrey" wrote: On Fri, 31 Mar 2006 14:30:02 -0800, Bryan Brassell wrote: Need to count the number of rows that contain data - ignoring formats. How are you defining data? Is that any piece of information, i.e. text, formula or number. Does just one occurence of a piece of data in a row mean that you count the row, or does every row have to contain data in every cell in a range of columns before you count the row? Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count filled data rows until empty | Excel Discussion (Misc queries) | |||
| How to count rows with changing data | Excel Worksheet Functions | |||
| Count all rows in column with data, Except rows 1-5 | Excel Worksheet Functions | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
| count only the visible rows in a data table | Excel Programming | |||
Hybrid Mode
