Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of occurences in a list | Excel Worksheet Functions | |||
how to count the number of occurences of a letter ? | Excel Discussion (Misc queries) | |||
Creating number formula to count number occurences in a data set | Excel Programming | |||
How to count number of occurences of two different things at once? | Excel Worksheet Functions | |||
count number of occurences within a string | Excel Worksheet Functions |