LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Count number of like occurences across all worksheet within workbo

Hello,

I'm in search of a way to count how many times a certain line of data
appears across many worksheets to summarize on a new worksheet within the
same workbook.

Example. My workbook may contain 60 worksheets from July 15- Sept 15, 1 for
each day. Each sheet has many lines of data spanning from Row 1; Column A-T,
Row 2; Column A-T and so forth.

There are times where the same row of data will appear for 'x' number of
days in a row. I'd like to get an analysis across all 60 sheets counting
the number of times the same row of data appears across these 60 worksheets.

If this reads confusing, let me know and I'll try to clarify better.

Thank you in advance.

Mike


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of occurences in a list Lucas Reece Excel Worksheet Functions 12 May 28th 09 10:23 PM
how to count the number of occurences of a letter ? [email protected] Excel Discussion (Misc queries) 3 November 26th 08 02:30 PM
Creating number formula to count number occurences in a data set Brreese24 Excel Programming 1 August 23rd 07 11:18 PM
How to count number of occurences of two different things at once? Cairan O'Toole Excel Worksheet Functions 6 August 12th 07 10:12 AM
count number of occurences within a string Gabriel Excel Worksheet Functions 2 November 25th 04 04:17 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"