|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 21st, 2009, 05:48 PM
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
March 21st, 2009, 06:04 PM
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
March 21st, 2009, 06:37 PM
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
March 21st, 2009, 08:14 PM
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"))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
