| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet with most rows
I have a workbook containing 100+ sheets. Is it possible to find
which sheet has the most rows? The data columns in these sheets contain dates, coin grades and prices. I have created an Sheet Index (using ASAP) and would like to add the number of rows each sheet has to the appropriate cell in the Sheet Index. Is this possible? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet with most rows
If each sheet is setup to where column A is the first column that contains
data and that column contains the most rows of data. Assume you have your sheet names listed on a summary sheet in the range A1:A100. Try this in B1 and copy down as needed: =COUNTA(INDIRECT("'"&A1&"'!A:A")) -- Biff Microsoft Excel MVP "Jack Deuce" wrote in message ... I have a workbook containing 100+ sheets. Is it possible to find which sheet has the most rows? The data columns in these sheets contain dates, coin grades and prices. I have created an Sheet Index (using ASAP) and would like to add the number of rows each sheet has to the appropriate cell in the Sheet Index. Is this possible? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet with most rows
Thanks so much. Worked perfectly.
On Sat, 21 Mar 2009 14:04:33 -0400, "T. Valko" wrote: If each sheet is setup to where column A is the first column that contains data and that column contains the most rows of data. Assume you have your sheet names listed on a summary sheet in the range A1:A100. Try this in B1 and copy down as needed: =COUNTA(INDIRECT("'"&A1&"'!A:A")) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet with most rows
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jack Deuce" wrote in message ... Thanks so much. Worked perfectly. On Sat, 21 Mar 2009 14:04:33 -0400, "T. Valko" wrote: If each sheet is setup to where column A is the first column that contains data and that column contains the most rows of data. Assume you have your sheet names listed on a summary sheet in the range A1:A100. Try this in B1 and copy down as needed: =COUNTA(INDIRECT("'"&A1&"'!A:A")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
| instering rows in one worksheet that reflect another worksheet | Excel Worksheet Functions | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Hybrid Mode
