Spreadsheet: 54426d1254404693-finding-difference-in-separate-sheets-using-criteria-to-prepare-for-a-pivot-table-shortfall-24-09-09-1-10-09-pivot-
Sheet: petes warehouse loc.

Inventory Number | JI Warehouse Location
2002 | SNT
2003 | SNT
2004 | SNT
2006 | SNT
2010 | SNT
2220 | SNT
2221 | SNT
2222 | SNT
2223 | SNT
2225 | SNT
2626 | SNT
2627 | SNT
10-SEE-BRN | 6
12STR-PB-10 | 29
4-STR-40 | 29
4-STR-45 | 29
4-STR-50 | 29
5-STR-40 | 29
5-STR-45 | 29
5-STR-50 | 29
5xKI015WKS | AH
5xKI030WKS | AH
71-CLR | 17
72-CL | 17
75-CLR | 17
76-CLR | 17
87-CLR | 17
92-CLR | 17
AGM-100 | 20
AGN-5A-FLW | 22
AO-1 | TR
ATZ1001 | AT
ATZ1004 | AT
ATZ10041 | AT
ATZ10042 | AT
AX-25-N2 | 7
AX-27-K | 7
B-25-BG | 25
BA-18 | BA
[NAME] | BA
BA-24 | BA
[NAME] | BA
BA-34 | BA
BA-35 | BA
BA-36 | BA
BA-38 | BA
BA-40 | BA
BA-41 | BA
BC-80-A | 19
BC-80-B | 19
BC-82-B | 19
BC-82-C | 19
BC-84-B | 19
BC-84-C | 19
[NAME] | 18
BD-1 | TR
BDP-020 | 3
BDP-060 | 3
[NAME] | 3
BDP-200 | 3
BEP-10-BK | 19
BEP-10-CH | 19
BEP-10-GD | 19
BEQ-1 | 18
BG-402-BK | 11
BG-402-BU | 11
BG-402-NT | 11
BG-402-RD | 11
BG-402-WH | 11
BG-402-YE | 11
BLM-1 | 18
BOD-1 | 18
BS-105-BK | 26
[NAME] | 20
BTU-100 | 20
BTU-300 | 20
BTU-305 | 20
BTU-500 | 20
CAC-500-D | 25
CAC-500-D2 | 25
CAC-500-J | 25
CAP-DB-BLU | MISC
CBB-5 | 10
CBB-6 | 10
CBB-7 | 10
CBB-8 | 10
CBB-9 | 10
CCL-534 | 25
CE-100 | 18
CEG-500-SA | 25
CH-100 | 18
CJZ-500-16 | 25
CJZ-500-17 | 25
CJZ-500-18 | 25
CL-BE | 29
CL-HT | 29
CL-MT | 29
CP-1 | TR
CP-69356-BASS | 29
CS-100 | 18
CYB-600 | 27
CYB-70 | 27
D1010 | AH
DD-050 | 18
DD-100 | 18
D-KIT-7 | 24
DM-100 | 23
DM-50 | 23
DM-868 | 23
DS-100 | 18
[NAME] | 26
DVD-CFG1 | 9
DVD-CFG2 | 9
DVD-CFG3 | 9
DVD-CFG4 | 9
DVD-CFGALL | 9
[NAME] | 9
DVD-CRG2 | 9
DVD-CRG-ALL | 9
[NAME] | 9
[NAME] | 9
E-10 | 29
E-11 | 29
E-25-BG | 25
[NAME] | 29
[NAME] | 29
EQ-100 | 18
FC-510 | 22
FL-100 | 18
G-35 | 8
G-35-R | 8
GC-103-6BU | 14
GC-103-6RD | 14
GC-104-3BK | 13
GC-104-6BK | 13
GC-105-3BK | 13
GC-105-6BK | 13
GC-10-SEE-BLU | 6
GC-10-SEE-GRN | 6
GC-10-SEE-PUR | 6
GC-10-SEE-RED | 6
GC-20-SEE-BLU | 6
GC-20-SEE-GRN | 6
GC-20-SEE-PUR | 6
GC-20-SEE-RED | 6
GCE335 | AH
GCF-V01 | AH
GCLP02 | AH
GC-NTK-10SA | 13
GC-NTK-10SS | 13
GC-NTK-6SA | 13
GC-NTK-6SS | 13
GCTB01 | AH
GCTE01 | AH
GCWEABS | AH
GCXP01 | AH
GFS-25 | 19
GK-095-B | 27
GK-095-E | 27
GK-095-K | 27
GK-095-W | 27
GL-15-V | 8
GL-20-B | 8
GPB-05 | 22
GPS-800 | 20
GRCE-2U | AH
GS-150-A | 26
GS-156-E | 26
GS-260-A | 26
GS-266-E | 26
GS-270-C | 26
GS-47-BK | 26
GST-100-AGN | 28
GST-100-BK | 28
GST-100-CAM | 28
GST-100-DB | 28
GST-100-GY | 28
GST-100-NT | 28
GST-100-RD | 28
GST-205-BR | 28
GST-205-GN | 28
GST-205-PK | 28
GST-205-PU | 28
GST-205-WH | 28
GST-205-YE | 28
GST-215-BK | 28
GST-215-JB | 28
GST-215-RD | 28
GST-216-BK | 28
GST-282-BK | 28
GST-284-BK | 28
GST-288-BK | 28
[NAME] | 28
[NAME] | 28
GST-544-YE | 28
GST-580-BK | 28
GST-580-LB | 28
GST-580-RD | 28
GST-610-BK | 28
H90B-BK | TR
H90B-CR | TR
H90N-BK | TR
H90N-CR | TR
HAY-302-B | 22
HAY-305-A | 22
HAY-305-AN | 22
HAY-305-B | 22
HAY-307-A | 22
HAY-307-AN | 22
HH-1 | 20
HM-100 | 18
HP-7 | 24
HP-7-M | 23
HRM-20-A | 20
HRM-20-C | 20
HRM-20-D | 20
HRM-20-G | 20
HTA-40-BK | 10
HTA-40-BU | 10
HTA-40-RD | 10
HTA-40-WH | 10
HTA-40-YE | 10
KK20C33P | AH
KK28C33P | AH
KK8C15P | AH
KS-105-BK | 25
LD-5 | 24
LD-7-M | 24
LDI02 | AH
LP1-C | 20
LP4-B | 20
LP4-W | 20
M-032-BC | 7
M-037-BC | 7
MG-10 | 8
MG-3 | 23
MGB-10 | 1
MGB-20 | 1
MM-7 | 23
MM-8 | 23
MR-05 | 22
MS-1325-BK | 26
MS-1400-BK | 26
MS-50-BK | 26
MSE-MAT-ST | 28
MSE-MAT-TE | 28
MS-GLASS | 20
MVS-501-BK | 19
MVS-501-CR | 19
MVS-501-GD | 19
MXJ-5-BK | 14
MXX-10-BK | 14
MXX-5-BK | 14
NG-100 | 18
OB-60 | 26
OB-80 | 26
OC-100 | 18
OD-100 | 18
[NAME] | TR
[NAME] | TR
PAF4B-NK | TR
[NAME] | TR
PAF4N-DB | TR
[NAME] | TR
PAF4N-NK | TR
[NAME] | TR
PB-10 | 29
PB-11 | 29
PB-12 | 29
PB-13 | 29
PC-20-03H | 11
PC-60-03 | 11
PH-17 | 20
PL-10 | 8
PL-10-BW | 8
PL-10-OR | 8
PL-10-RD | 8
PN-1020-M | 21
PN-1020-R | 21
PN-1021-M | 21
PN-1021-R | 21
PP-418P10 | SNT
PP-418P114 | SNT
PP-418P50 | SNT
PP-418P60 | SNT
PP-418P73 | SNT
PP-418P88 | SNT
PP-41P114 | SNT
PP-41P15 | SNT
PP-41P20 | SNT
PP-41P46 | SNT
PP-41P71 | SNT
PP-41P96 | SNT
PP-44P10 | SNT
PP-44P38 | SNT
PP-44P46 | SNT
PP-44P60 | SNT
PP-44P73 | SNT
PP-44P88 | SNT
PP-474P10 | SNT
PP-474P20 | SNT
PP-474P30 | SNT
PP-475P10 | SNT
PP-475P20 | SNT
PP-475P30 | SNT
PS-1 | 23
PU-22-BK | 16
PU-54-RBKR | 16
R90B-NK | TR
R90N-NK | TR
RD-12 | 7
RD-17 | 7
RD-17C | 7
RD-17C-CE | 7
RD-17-CE | 7
RD-22 | 6
RD-22-CE | 6
RD-24 | 6
RD-24-CE | 6
RE-129-BK | 4
RE-129-BU | 4
RE-129-CS | 4
RE-129-GR | 4
RE-129-NT | 4
RE-129-OR | 4
RE-129-WH | 4
RE-135-BB | 1
RE-135-GY | 1
RE-135-HB | 1
RE-500-BU | 3
RE-500-GR | 3
RE-500-NT | 3
RE-500-OR | 3
RM-7 | 24
RS-17C-CE | 8
RV-100 | 18
SC-1 | TR
SD-100 | 18
SH-100 | 24
SJJ-10-BK | 14
SJS-10-BK | 14
SN-1021-M | 21
SN-1021-R | 21
SN-1022-M | 21
SN-1022-R | 21
[NAME] | 19
SSL-10-CH | 19
SSS-10-BK | 14
ST-313-B | 20
ST-313-M | 20
ST-313-W | 20
STR-3RC-BLU | 28
STR-3RC-GRN | 28
STR-BWS-BLK | 28
STR-CEL-BLK | 28
STR-CEL-DBRN | 28
STR-CEL-GRN | 28
STR-CEL-NAT | 28
STR-CEL-PUR | 28
STR-DLX-BLK | 28
STR-DLX-DBR | 28
STR-DLX-PUR | 28
STR-DLX-RED | 28
STR-DLX-TAN | 28
STR-ENG | 28
STR-LWS-BLK | 28
STR-OST-BU | 28
STR-PEB-BK | 28
STR-PEB-BR | 28
STR-PEB-TAN | 28
STR-SHO-BK | 28
STR-USL-BLK | 28
STR-USL-BRI | 28
STR-USL-DBN | 28
STR-USL-HON | 28
STR-USL-MAH | 28
STR-USL-VER | 28
STR-WVE-BLK | 28
STR-WVE-BRN | 28
STR-WVE-GRN | 28
STR-WVE-NAT | 28
STR-WVE-PUR | 28
T-250-C | 19
T-310-C | 19
TD-10-EPJ | 20
TE-310-B | 20
TE-310-M | 20
TN-1022-M | 21
TN-1022-R | 21
TRH1B-DB | TR
TRH1B-GD | TR
TRH1B-NK | TR
TRH1B-ZA | TR
TRH1N-DB | TR
TRH1N-GD | TR
TRH1N-NK | TR
TRH1N-ZA | TR
TRH2B-DB | TR
[NAME] | TR
TRH2B-NK | TR
TRH2B-ZA | TR
TRH2N-DB | TR
TRH2N-GD | TR
TRH2N-NK | TR
[NAME] | TR
TRJ1B-BK | TR
TRJ1N-BK | TR
TRP1-BK | TR
TRS1SET | TR
TRS1SET-LH | TR
TRS2SET | TR
TRS3SET | TR
TRT1B | TR
[NAME] | TR
TRT1N-NK | TR
TRT2B | TR
TRT2N-GD | TR
TRT2N-NK | TR
TS-BBK-BK | 28
TS-BBK-BK-XL | 28
TS-EX-BK | 28
TS-LP-BK | 28
TS-LP-BK-XL | 28
TS-RK-BK | 28
TS-RK-BK-XL | 28
TS-RRL-BK | 28
TS-SG-BK | 28
TS-SG-BK-XL | 28
TS-ST-BK | 28
TS-TL-BK | 28
TS-TWN-BK | 28
TS-TWN-BK-XL | 28
U2-KIT-CBK | 5
U2-KIT-CBU | 5
U2-KIT-CGN | 5
U2-KIT-CPK | 5
U2-KIT-CPP | 5
[NAME] | 4
[NAME] | 4
[NAME] | 4
[NAME] | 4
U-30G-OR | 4
U-30G-PK | 4
[NAME] | 4
[NAME] | 4
U-30G-WH | 4
U-30G-YE | 4
UFV-1-BK | 10
UFV-1-PK | 10
UFV-1-WH | 10
UI-KIT-LBU | 5
UI-KIT-RD | 5
UI-KIT-WT | 5
UI-KIT-YW | 5
UK-185 | 12
ULP-1-BK | 5
ULP-1-CS | 5
ULP-1E-BK | 5
ULP-1E-CS | 5
ULP-1E-VS | 5
ULP-1-VS | 5
UNG-30-BK | 12
UNG-30-BU | 12
UNG-30-GN | 12
UNG-30-OR | 12
UNG-30-PP | 12
UNG-30-RD | 12
UNG-30-WH | 12
UNG-30-YW | 12
USG-30-BK | 8
USG-30-BU | 8
USG-30-GN | 8
USG-30-LBU | 8
USG-30-OR | 8
USG-30-PK | 8
USG-30-PP | 8
USG-30-RD | 8
USG-30-WH | 8
USG-30-YW | 8
VE-05-AGN | 4
VE-05-AWH | 4
VE-05-CBK | 4
VE-05-CRD | 4
VE-07-BK | 4
VE-07-RD | 4
VE-08-SB | 4
W-25-BG | 25
ZAKK-BULL-BLK | MISC
ZAKK-BULL-WHT | MISC