Allocated work via excel - complex formula or VBA

T

thedeadzeds

Active Member
Joined
Aug 16, 2011
Messages
451
Office Version
  1. 365
Platform
  1. Windows
Hi Guys,

I've been using excel to allocate work equally. Up until now this works ok but the formula i am using essentially looks at a list of work, looks at the staff members in the list called Blue Team Names and allocates out evenly. There are 2 tables below. To give you an idea the below formulas are used in the data table:

Column D (Additional work) =IF(OR(B2=B1, B1=B2, B2=B3), "Yes", "")
This column essentially looks at the number in the reg columns and if this is equal to the number above or below, then shows YES. Essentially picks up duplicates.

Column E (Allocated) =IF(COUNTIF(C$2:C2,C2)<=INT(COUNTIF($C$2:INDEX(C:C,MATCH(REPT("Z",255),C:C)),C2)/COUNTA(Blue_Team_Names[Name Lookup]))*COUNTA(Blue_Team_Names[Name Lookup]),INDEX(Blue_Team_Names[Name Lookup],MOD(COUNTIF(C$2:C2,C2)-1,COUNTA(Blue_Team_Names[Name Lookup]))+1),"Not allocated")
This column looks at all the types of work in the type column and equally allocates out the type of work based on the names in the blue team name list.

Column F (Allocated 2) =IF(D2="Yes",INDEX(E:E,MATCH(B2,B:B,0)),E2)
This column looks at the additional work column and if there is a yes, then it pulls in the name from the allocated column so essentially that person will be allocated all same regno numbers.

This works great but ideally i want to be able to allocate based on what i enter in the table below (allocate table).

I'm not even sure if this is possible but i hope this makes sense.

Many thanks


Allocate Table

[TABLE="class: grid, width: 1121"]
<tbody>[TR]
[TD="align: center"]Dealer[/TD]
[TD="align: center"]Type[/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Not Allocated[/TD]
[TD="align: center"]Available to allocate[/TD]
[TD="align: center"]Total Allocated[/TD]
[TD="align: center"]Check[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Ok[/TD]
[/TR]
</tbody>[/TABLE]


DATA TABLE BELOW:
[TABLE="class: grid, width: 1003"]
<tbody>[TR]
[TD="align: center"]Dealer[/TD]
[TD="align: center"]RegNo[/TD]
[TD="align: center"]Type[/TD]
[TD="align: center"]Additional Work[/TD]
[TD="align: center"]Allocated[/TD]
[TD="align: center"]Allocated 2[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts First Attempt Made[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]33[/TD]
[TD="align: center"]POLK Cam Belt Due First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]37[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]POLK Cam Belt Due New Call[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]49[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]51[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]53[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]57[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]58[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]61[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]62[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]63[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]64[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]66[/TD]
[TD="align: center"]POLK Brake Fluid Change First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]POLK 1st Wave MOT Contacts First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]CVW[/TD]
[TD="align: center"]68[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]69[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]71[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Bethan[/TD]
[TD="align: center"]Bethan[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Nicole F[/TD]
[TD="align: center"]Nicole F[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]73[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Sonia[/TD]
[TD="align: center"]Sonia[/TD]
[/TR]
[TR]
[TD="align: center"]CF[/TD]
[TD="align: center"]74[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hannah[/TD]
[TD="align: center"]Hannah[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]76[/TD]
[TD="align: center"]POLK 1st Wave Service Contacts New Call[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Jodie[/TD]
[TD="align: center"]Jodie[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]78[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]BVW[/TD]
[TD="align: center"]79[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]NSK[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
[TR]
[TD="align: center"]MCH[/TD]
[TD="align: center"]81[/TD]
[TD="align: center"]3rd Chance MOT First Attempt Made[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Not allocated[/TD]
[TD="align: center"]Not allocated[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top