counting occurences

Hi Everyone, I am pretty much useless at formula writing. I need a pivot table to be able to calculate the following data (below) as number of different subjects (count all duplicates as 1 but only for the specified teacher( eg:10 subjects instead of 12 (total number) or 7 (counting ALL math as...

<tbody> Deal ID Sales Rep Quarter Value Product <tbody> 0087060 </tbody> Fred Blogs 4 1.000 bread <tbody> 0087060 </tbody> Fred Blogs 4 20.000 butter <tbody> 0087061 </tbody> Fred Blogs 3 45.000 bread <tbody> 0087763 </tbody> John Smith 4 30.000 bread <tbody>...

I am racking my brain on this problem, and I can’t help but think there must be a better solution. I am trying to create a formula that counts the number of facilities that have findings in each of the areas (There are 80+ areas) :confused::banghead::help: I am trying to put together an excel...

Hi, I have a large list of policy numbers with different letters held within (eg MT/1/PD/101271A, 07BV/17345057, BL/1/ /635663A, MALZ32741) all have different formats and some contain /'s. They have all been manually added so each line differs slightly. I have a list of letter prefixes i wish...

Hi all. I currently have files that I track M-F, and some files come in on the weekend. I've been using a macro for a while, but have never been able to tweak it correctly to get the right counts. Below is a sample of files received, and then the macro used to get a count. Shown in orange...

I need to count backwards the runs of occurances of consectutive Ys (yes's) which are interupted by Ns. So for example we have: <tbody> Months: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Ys &Ns Y Y Y Y Y Y N Y N N Y Y Y Y Y Y...

I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error")) ... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type). Instead of finding the sum of the 'Quantity', can...

Hi! There are a lot of similar questions on here, and I've tried out a few things without much luck. I have a table that looks like this: <TABLE style="WIDTH: 242pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=323><COLGROUP><COL style="WIDTH: 50pt; mso-width-source...