Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have data in a Worksheet (Sheet1) in Columns A and B, the number of rows of data is variable. The first and last row of data is a header and footer. I need to count the rows in between the header and footer (not counting the header and footer rows) and place this count (same number) in the header row and footer row in Coulum C. For example the count in the header row would be placed in cell C1 and the count in the footer is in cell CX (x being a variable) I hope this is clear Thanks for any help Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count count multiple rows | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) |