Using COUNT for text occurances in unusual worksheet?
 

I am using Excel 2003 and I need to count how many times specific text
appears. Here's the catch ... my worksheet is set up as follows:

A - First Name
B - Last Name
C - Badge (ID)
D - Store No.
E - ScanDttm (work day)
F thru AB - [contain various formulas I used to calculate time punch info]
AC thru AK - [contain formulas I used with a TRUE/FALSE or n/a result to
determine if an individual worked certain hour thresholds during the day,
i.e. "MORE THAN 5 HRS.", "BETWEEN 5 & 5:15", 'MORE THAN 6 HRS", etc.]

For the purpose of attempting to count text occurances, I have created a
second copy of the worksheet where the TRUE/FALSE or n/a results are text and
not formulas - I hope that helps. My problem is adding up how many times
TRUE, FALSE & n/a appear for each individual because my data is set up where
each person has multiple rows of information depending upon the number of
days they worked (column E). My first person has data in rows 2 thru 13, the
next person has data in rows 14 thru 66, etc. It is different for each
person.

I have over 60 worksheets with an average 3500 rows of data that I need to
calculate. Yikes! Can someone help? Your assistance would be greatly
appreciated!

---
heyredone

Using COUNT for text occurances in unusual worksheet?
 

I may have figured out that using a Pivot Table may work for my dilemna.
Although I would still like to hear if anyone has any suggestions regarding
my inquiry.
Thank you!
--
heyredone


"heyredone" wrote:

I am using Excel 2003 and I need to count how many times specific text
appears. Here's the catch ... my worksheet is set up as follows:

A - First Name
B - Last Name
C - Badge (ID)
D - Store No.
E - ScanDttm (work day)
F thru AB - [contain various formulas I used to calculate time punch info]
AC thru AK - [contain formulas I used with a TRUE/FALSE or n/a result to
determine if an individual worked certain hour thresholds during the day,
i.e. "MORE THAN 5 HRS.", "BETWEEN 5 & 5:15", 'MORE THAN 6 HRS", etc.]

For the purpose of attempting to count text occurances, I have created a
second copy of the worksheet where the TRUE/FALSE or n/a results are text and
not formulas - I hope that helps. My problem is adding up how many times
TRUE, FALSE & n/a appear for each individual because my data is set up where
each person has multiple rows of information depending upon the number of
days they worked (column E). My first person has data in rows 2 thru 13, the
next person has data in rows 14 thru 66, etc. It is different for each
person.

I have over 60 worksheets with an average 3500 rows of data that I need to
calculate. Yikes! Can someone help? Your assistance would be greatly
appreciated!

---
heyredone

Using COUNT for text occurances in unusual worksheet?
 

On Wed, 4 Mar 2009 16:05:01 -0800, heyredone
wrote:

I am using Excel 2003 and I need to count how many times specific text
appears. Here's the catch ... my worksheet is set up as follows:

A - First Name
B - Last Name
C - Badge (ID)
D - Store No.
E - ScanDttm (work day)
F thru AB - [contain various formulas I used to calculate time punch info]
AC thru AK - [contain formulas I used with a TRUE/FALSE or n/a result to
determine if an individual worked certain hour thresholds during the day,
i.e. "MORE THAN 5 HRS.", "BETWEEN 5 & 5:15", 'MORE THAN 6 HRS", etc.]

For the purpose of attempting to count text occurances, I have created a
second copy of the worksheet where the TRUE/FALSE or n/a results are text and
not formulas - I hope that helps. My problem is adding up how many times
TRUE, FALSE & n/a appear for each individual because my data is set up where
each person has multiple rows of information depending upon the number of
days they worked (column E). My first person has data in rows 2 thru 13, the
next person has data in rows 14 thru 66, etc. It is different for each
person.

I have over 60 worksheets with an average 3500 rows of data that I need to
calculate. Yikes! Can someone help? Your assistance would be greatly
appreciated!

---
heyredone

I don't believe the 2nd worksheet copy will be necessary. I believe you may be
able to summarize your data appropriately using a Pivot Table.

--ron

Using COUNT for text occurances in unusual worksheet?
 

Using a Pivot Table did the trick. I now need to use the Pivot Tables in a
more advanced way and I'm a novice at this. Will look in Discussion Group for
answers, otherwise, will post further inquiries. Thank you
--
heyredone


"Ron Rosenfeld" wrote:

On Wed, 4 Mar 2009 16:05:01 -0800, heyredone
wrote:

I am using Excel 2003 and I need to count how many times specific text
appears. Here's the catch ... my worksheet is set up as follows:

A - First Name
B - Last Name
C - Badge (ID)
D - Store No.
E - ScanDttm (work day)
F thru AB - [contain various formulas I used to calculate time punch info]
AC thru AK - [contain formulas I used with a TRUE/FALSE or n/a result to
determine if an individual worked certain hour thresholds during the day,
i.e. "MORE THAN 5 HRS.", "BETWEEN 5 & 5:15", 'MORE THAN 6 HRS", etc.]

For the purpose of attempting to count text occurances, I have created a
second copy of the worksheet where the TRUE/FALSE or n/a results are text and
not formulas - I hope that helps. My problem is adding up how many times
TRUE, FALSE & n/a appear for each individual because my data is set up where
each person has multiple rows of information depending upon the number of
days they worked (column E). My first person has data in rows 2 thru 13, the
next person has data in rows 14 thru 66, etc. It is different for each
person.

I have over 60 worksheets with an average 3500 rows of data that I need to
calculate. Yikes! Can someone help? Your assistance would be greatly
appreciated!

---
heyredone

I don't believe the 2nd worksheet copy will be necessary. I believe you may be
able to summarize your data appropriately using a Pivot Table.

--ron

Using COUNT for text occurances in unusual worksheet?
 

On Fri, 6 Mar 2009 11:57:01 -0800, heyredone
wrote:

Using a Pivot Table did the trick. I now need to use the Pivot Tables in a
more advanced way and I'm a novice at this. Will look in Discussion Group for
answers, otherwise, will post further inquiries. Thank you
--
heyredone

Good to hear. Thanks for the feedback.
--ron