I need to filter a schedule

D

dzoomz

New Member
Joined
Oct 30, 2010
Messages
17
:confused:

Well:


I have a monthly schedule of 50 persons 7 different work groups with different rotating work weeks and shifts (M, Morning)(D, Day)(N, Night)(O, Off).
From the schedule I have to filter each day to get the people that work each shift and cut and paste to a daily prevision list to know how is working and where.
My idea is to have in a monthly folder with a spread sheet with the schedule and 31 other sheets that retrieve the daily info needed from the schedule for printing.
I have all ready have a daily prevision list linked to daily sign in sheets and total work hrs list but I can’t figure out how to automatically filter and send the list from my schedule to a different work sheet (Prevision list).




Thank you very much if you can help.
Email address removed by Moderator - refer Posting Rules
 
Last edited by a moderator:
Sort by date Sort by votes
OK. I finally have had time to work on this and lightly understand what I’m doing.


I have got it to work and is working…………….but with a few problems.


After row 46 it doesn’t display the names in the columns D, E & F. Columns A, B & C do show the position and work good. When I input day 14 & 28 in the bottom tab some of the names come out as 0 in column F.

On my Master Sheet (schedule) there are 7 different work groups all separated by blank spaces and I do need some space between the names to see the different groups and some of them do differ on the amount of people in the group on a day by day basis. All these groups do have a header with days and date.


I have tried the formulas for the older versions with no luck. No name position and no names.


One of the problems I may encounter is that the PC at work is in Spanish, EXCEL dose translate the formulas but may not do them all I will have to study that one also.
 
Upvote 0
It is important that the formulas are correct in that the "$" are there as shown in the examples - copy/pasting ensures that they are correct.
Also, they need to be copied-down far enough on all worksheets to ensure that the data can be found.
However, I think that your problem may be the grouping and blank lines which was not clear from the example that you gave. I would not expect this techique to work where the data is not structured the way that Excel likes to see - headings in row 1, no blank columns and no blank rows.
The reason why the blank rows may cause a problem is that the 'previous' row defines the starting point for the search.
In order to advise further, I would need to see an example that shows how the different groups appear on the worksheet. Are you able to do that, please?
 
Upvote 0
[FONT=&quot] <hr style="color: white;" width="100%" align="center" noshade="noshade" size="1"> [/FONT]​
<table class="MsoNormalTable" style="width: 252.15pt; margin-left: 1.5pt; border-collapse: collapse;" width="420" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
S​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
D​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
X​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
J​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
ENCARGADO​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
1​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
2​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
3​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
4​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
5​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
6​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border: 1pt solid windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> DAVID SMITH
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> MIGUEL ANGEL ROBLES
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> MIGUEL RIOS ARIAS
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
S​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
D​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
X​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
J​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
GRUAS​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
1​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
2​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
3​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
4​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
5​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
6​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border: 1pt solid windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> JUAN JOSE OGAYAR SANCHEZ
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> MANUEL GOMEZ CASALES
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> JOSE LUIS GONZALEZ
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> MANUEL NIETO OLMEDO
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> </tr> <tr style="height: 4.25pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="256" nowrap="nowrap"> PEDRO IVAN VALLEJO BARBA
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> JAVIER DEL CERRO GARCIA
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> CAYETANO CID BENITO
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> ALBERTO SAIZ ARROYO
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap"> DIEGO ISRAEL MARTINEZ TAPIA
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
S​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
D​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
X​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
J​
</td> </tr> <tr style="height: 4.25pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="256" nowrap="nowrap">
NEPTUNO DIA​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
1​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
2​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
3​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
4​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
5​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
6​
</td> </tr> <tr style="height: 4.25pt;"> <td style="width: 153.45pt; border: 1pt solid windowtext; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="256" nowrap="nowrap"> JUANA IGLESIAS LOPEZ
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> </tr> <tr style="height: 4.25pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="256" nowrap="nowrap"> RAFAEL SANTIAGO ANAYA
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
M​
</td> </tr> <tr style="height: 4.25pt;"> <td style="width: 153.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="256" nowrap="nowrap"> LOURDES ATAHUALPA
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% yellow; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
L​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> <td style="width: 16.45pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 3.5pt; height: 4.25pt;" valign="bottom" width="27" nowrap="nowrap">
T​
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> <tr style="height: 4.05pt;"> <td style="width: 153.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="256" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> <td style="width: 16.45pt; padding: 0cm 3.5pt; height: 4.05pt;" valign="bottom" width="27" nowrap="nowrap">
</td> </tr> </tbody></table>

Ok
Here is part of what it looks like.
When I started this I was thinking of applying the formula to each section so I could leave blank lines on the prevision list for writing names of people doing substitutions during sick leave, vacations and other odds and ends. On the prevision list I also need to know what work group the person belongs to. Right now I have each group assigned to a specific range on my sheet.
 
Upvote 0
The given solution will not work with the worksheet as you now describe. There needs to be no blank rows and data in a column must be consistent with the column header.
You wuld need to have the group in a separate column, either before or after the name, and the formulas would need a slight adjustment. You could then have the names in alphabetical order to make it easier to find a person.
 
Upvote 0
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Hello & Marry X-mass
Now it works well.
I have finally finished restructuring the schedule with no empty spaces. You were right that Excel didn´t like the empty rows I had in it.

Having the work group name after the prisons name I think will work well.
I think I am ready for the old fashion formulas for older versions of EXCEL.
In step 3, ¿If I would to have the date (1-JAN-11) in E3 & the Work Sheet tab what do I have to do to the formula?
 
Upvote 0
Hello - hope that you had a good Christmas.
Here are the formulas that will work for all version of Excel (somewhat longer than the Excel 2007/2010 formulas that have the new function IFERROR).
You will need to repeat steps 6, 7 and 8 using the revised formulas below:
Step 6.
=IF(ISERROR(MATCH(A$2,OFFSET('Master Sheet'!$A$1,2,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+2),"",MATCH(A$2,OFFSET('Master Sheet'!$A$1,2,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+2)
Step 7.
=IF(ISERROR(MATCH(A$2,OFFSET('Master Sheet'!$A$1,A3,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+A3),"",MATCH(A$2,OFFSET('Master Sheet'!$A$1,A3,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+A3)
Step 8.
=IF(ISERROR(INDEX(OFFSET('Master Sheet'!$A$1,0,0,$A$1,1),A3,1)),"",INDEX(OFFSET('Master Sheet'!$A$1,0,0,$A$1,1),A3,1))

Not quite sure that I understand the question regarding the date in E3. If you mean that you want to have the date as the worksheet name, then try changing the Step 3 formula to:
=DAY(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256))
but note that I have not tested that.
If you want the date also to be in E3 then I suggest that after you have entered all the formulas, try adding some new rows (but try it in a COPY of the workbook first) where you want them - Excel should then adjust the other formulas.
If I have not understood the question, perhaps you can give an example of what the worksheet needs to look like?
 
Upvote 0
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Sorry but it´s not working.
I`ve been trying to get it to work but nothing happens, the formulas just sit there in the cells as if they were regular script. Not even an error message is displayed during the copy and past process.
But if I go into the formula and press enter it says “the formula contains an error.”


[FONT=&quot]=IF(ISERROR(MATCH(A$2,OFFSET('Master Sheet'!$A$1,2,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+2),"",MATCH(A$2,OFFSET('Master Sheet'!$A$1,2,MATCH($E$1,'Master Sheet'!$B$2:$AF$2,0),COUNTA('Master Sheet'!$A:$A)-1,1),0)+2)[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have tried to save it before an after as a EXCEL 97 – 2003 work book and it tells me that …”one or more of these functions are not available in earlier versions of EXCEL. When recalculated the function will return #NAME?[/FONT]
 
Upvote 0
The formulas that I gave on 27th December have been tested in Excel 2010, Excel 2007 and Excel 2003 and all work correctly in all three versions.
I have compared the formula that you posted and compared it with mine (using Excel to compare them) and it is identical.
the formulas just sit there in the cells as if they were regular script
Click to expand...
- this usually indicates that you have pasted the formula into a cell formatted as text. Just changing it to 'General' will not correct the problem. I suggest that you create a new worksheet, adding the formulas and see what happens then.
The #NAME is interesting. I would expect something like this if you typed the formula instead of using copy/paste (and I would do that in the formula bar and not directly in the cell itself) and missing out the apostrophes around the worksheet name (Master Sheet). Here I would use the Excel 'Evaluate Formula' feature to find out exactly which part of the formula it didn't like.
 
Upvote 0
All right, I have it working 110% now.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
The problem was that I had opened several work sheets in spanish format and Excel took the function as script being in a different language.;)<o:p></o:p>
But I knew I was going to have a problem in that area and for my luck during the holidays they had been talking about a VBA for translating formulas from English to different languages in the MREXCEL FORUM - Questions in Other Languages.<o:p></o:p>
<o:p></o:p>
As for the date as work sheet name I just changed the numbers (1,2,3) for numeric dates (2-3-11) and changed the cell format to date so that the month will come out in script on my sheets and although it dose come out in lower case it works good and now I have 9 months of previsions at the tip of my finger.:cool:<o:p></o:p>
<o:p></o:p>
Muchos Thank You´s and Thank You Very Muchos.

Dzoomz
 
Upvote 0
Thank you for the update - it is good to know the cause of problems (for future reference).
Pleased that it is now working for you - well done!
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Automate Attendance Marking Based on Daily Schedule in Excel
Replies
1
Views
395
Peter_SSs
Peter_SSs
S
  • Question Question
Xlookup Formula Issue.
Replies
2
Views
189
rcocrane99
R
A
  • Question Question
VBA and Windows Scheduler
Replies
1
Views
191
Micron
M
B
  • Question Question
Excel VBA Searching Unique Variables to Match against Exported Schedule Files to Determine Date
Replies
1
Views
566
sijpie
sijpie
A
  • Question Question
Looking for help in Excel Macros scripts
Replies
0
Views
185
Adnan199
A

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