-
Trying XL2BB from MrExcel here:
[RANGE=cls:xl2bb-100][XR][XH=cs:5]xl2bb.xlam[/XH][/XR][XR][XH][/XH][XH=w:207.75]A[/XH][XH=w:107.25]B[/XH][XH=w:51]C[/XH][XH=w:164.25]D[/XH][/XR][XR][XH=ch:21]1[/XH][XD=fw:b|cls:bb][/XD][XD=fw:b][/XD][XD=fw:b][/XD][XD=h:l|fw:b|fz:16pt]7A-7P DAILY STAFFING[/XD][/XR][XR][XH=ch:18.75]2[/XH][XD=h:c|fw:b|fz:14pt|cls:bt bb]2 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]3 MED/SURG[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]ED[/XD][XD=h:c|fw:b|fz:14pt|cls:bb]FLOAT POOL[/XD][/XR][XR][XH=ch:18.75]3[/XH][XD=h:c|fw:b|bc:E2EFDA|fz:14pt|cls:bt]29/09/2019[/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][XD=h:c|fw:b|cls:bt][/XD][/XR][XR][XH=ch:15]4[/XH][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]CN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][/XR][XR][XH=ch:15]5[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]6[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]7[/XH][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:c|fw:b|fz:11pt]RN[/XD][XD=h:l][/XD][/XR][XR][XH=ch:15]8[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Joe[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN17[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]9[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jack[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN18[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]10[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]Jane[/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN20[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]11[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}]NameRN23[/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]12[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]13[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]14[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]15[/XH][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0 ,MATCH($A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD=h:l|bc:E2EFDA|fz:9pt|cls:fx][FORMULA={=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0 ,MATCH($A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}][/FORMULA][/XD][XD][/XD][XD][/XD][/XR][XR][XH=ch:15]16[/XH][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b|fz:11pt]LPN[/XD][XD=h:c|fw:b][/XD][XD=h:c|fw:b][/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Housewide[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][RANGE=cls:xl2bb-extra-100][XR][XH=cs:3]Cell Formulas[/XH][/XR][XR][XH]Range(s)[/XH][XH=cs:2]Formula[/XH][/XR][XR][XD]A8:A15[/XD][XD]A8[/XD][XD]{=IFERROR(INDEX('2nd'!$B$5:$B$20,SMALL(IF(INDEX('2nd'!$C$5:$AR$20,0,MATCH($ A$3,'2nd'!$C$4:$AR$4,0))="a",ROW('2nd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD]B8:B15[/XD][XD]B8[/XD][XD]{=IFERROR(INDEX('3rd'!$B$5:$B$20,SMALL(IF(INDEX('3rd'!$C$5:$AR$20,0,MATCH($ A$3,'3rd'!$C$4:$AR$4,0))="a",ROW('3rd'!$B$5:$B$20)-4,FALSE),ROW()-7)),"")}[/XD][/XR][XR][XD=cs:3|p:5|fz:0.85em]Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.[/XD][/XR][/RANGE]
Last edited by p45cal; 12-23-2019 at 05:21 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules