Spreadsheet: 166331d1341555015-help-with-matching-data-min-max-between-sheets-career-stats-abridged
Sheet: FINAL PRODUCT

 | TEAM | PLAYER | AMOUNT | SEASON |  |  |  | [NAME]
G | BOSTON |  |  |  | <-------- | we have to repeat this formulas again for the remaining Teams( every team )
A | BOSTON |  |  |  |  | the formula increments the column by 1 so find maximum every column.....
P | BOSTON |  |  |  |  | because we will go back again to the first column G which
PlusMinus | BOSTON
PIM | BOSTON
PPG | BOSTON
SHG | BOSTON
GWG | BOSTON
HITS | BOSTON
SHOTS | BOSTON
[NAME] | BOSTON
[NAME] | BOSTON
[NAME] | BOSTON
G. T | BOSTON
GA | BOSTON
GAA | BOSTON
SAVES | BOSTON
SA % | BOSTON
SO | BOSTON
PIM | BOSTON
A | BOSTON
WINS | BOSTON
LOSSES | BOSTON
TIES | BOSTON
POINTS | BOSTON
GF | BOSTON
GA | BOSTON
[NAME] | BOSTON
Least Losses | BOSTON
Least Ties | BOSTON
Least Points | BOSTON
Least GF | BOSTON
Least GA | BOSTON
G | BUFFALO |  |  |  |  | <--- LOOK HERE ONLY REFERENCE WILL CHANGE THEN BACK TO COLUMN g OF SHEET stats
A | BUFFALO |  |  |  |  | MAX(IF(STATS!$B$1:$B$1000='FINAL PRODUCT'!B35,INDIRECT("STATS!"&ADDRESS(1,ROWS($1:7))&":"&ADDRESS(1000,ROWS($1:7)))))
P | BUFFALO
PlusMinus | BUFFALO
PIM | BUFFALO
PPG | BUFFALO
SHG | BUFFALO
GWG | BUFFALO
HITS | BUFFALO
SHOTS | BUFFALO
[NAME] | BUFFALO
[NAME] | BUFFALO
[NAME] | BUFFALO
G. T | BUFFALO
GA | BUFFALO
GAA | BUFFALO
SAVES | BUFFALO
SA % | BUFFALO
SO | BUFFALO
PIM | BUFFALO
A | BUFFALO
WINS | BUFFALO
LOSSES | BUFFALO
TIES | BUFFALO
POINTS | BUFFALO
GF | BUFFALO
GA | BUFFALO
[NAME] | BUFFALO
Least Losses | BUFFALO
Least Ties | BUFFALO
Least Points | BUFFALO
Least GF | BUFFALO
Least GA | BUFFALO
G | CALGARY
A | CALGARY
P | CALGARY
PlusMinus | CALGARY
PIM | CALGARY
PPG | CALGARY
SHG | CALGARY
GWG | CALGARY
HITS | CALGARY
SHOTS | CALGARY
[NAME] | CALGARY
[NAME] | CALGARY
[NAME] | CALGARY
G. T | CALGARY
GA | CALGARY
GAA | CALGARY
SAVES | CALGARY
SA % | CALGARY
SO | CALGARY
PIM | CALGARY
A | CALGARY
WINS | CALGARY
LOSSES | CALGARY
TIES | CALGARY
POINTS | CALGARY
GF | CALGARY
GA | CALGARY
[NAME] | CALGARY
Least Losses | CALGARY
Least Ties | CALGARY
Least Points | CALGARY
Least GF | CALGARY
Least GA | CALGARY
G | CHICAGO
A | CHICAGO
P | CHICAGO
PlusMinus | CHICAGO
PIM | CHICAGO
PPG | CHICAGO
SHG | CHICAGO
GWG | CHICAGO
HITS | CHICAGO
SHOTS | CHICAGO
[NAME] | CHICAGO
[NAME] | CHICAGO
[NAME] | CHICAGO
G. T | CHICAGO
GA | CHICAGO
GAA | CHICAGO
SAVES | CHICAGO
SA % | CHICAGO
SO | CHICAGO
PIM | CHICAGO
A | CHICAGO
WINS | CHICAGO
LOSSES | CHICAGO
TIES | CHICAGO
POINTS | CHICAGO
GF | CHICAGO
GA | CHICAGO
[NAME] | CHICAGO
Least Losses | CHICAGO
Least Ties | CHICAGO
Least Points | CHICAGO
Least GF | CHICAGO
Least GA | CHICAGO
G | COLORADO
A | COLORADO
P | COLORADO
PlusMinus | COLORADO
PIM | COLORADO
PPG | COLORADO
SHG | COLORADO
GWG | COLORADO
HITS | COLORADO
SHOTS | COLORADO
[NAME] | COLORADO
[NAME] | COLORADO
[NAME] | COLORADO
G. T | COLORADO
GA | COLORADO
GAA | COLORADO
SAVES | COLORADO
SA % | COLORADO
SO | COLORADO
PIM | COLORADO
A | COLORADO
WINS | COLORADO
LOSSES | COLORADO
TIES | COLORADO
POINTS | COLORADO
GF | COLORADO
GA | COLORADO
[NAME] | COLORADO
Least Losses | COLORADO
Least Ties | COLORADO
Least Points | COLORADO
Least GF | COLORADO
Least GA | COLORADO
G | DETROIT
A | DETROIT
P | DETROIT
PlusMinus | DETROIT
PIM | DETROIT
PPG | DETROIT
SHG | DETROIT
GWG | DETROIT
HITS | DETROIT
SHOTS | DETROIT
[NAME] | DETROIT
[NAME] | DETROIT
[NAME] | DETROIT
G. T | DETROIT
GA | DETROIT
GAA | DETROIT
SAVES | DETROIT
SA % | DETROIT
SO | DETROIT
PIM | DETROIT
A | DETROIT
WINS | DETROIT
LOSSES | DETROIT
TIES | DETROIT
POINTS | DETROIT
GF | DETROIT
GA | DETROIT
[NAME] | DETROIT
Least Losses | DETROIT
Least Ties | DETROIT
Least Points | DETROIT
Least GF | DETROIT
Least GA | DETROIT
G | EDMONTON
A | EDMONTON
P | EDMONTON
PlusMinus | EDMONTON
PIM | EDMONTON
PPG | EDMONTON
SHG | EDMONTON
GWG | EDMONTON
HITS | EDMONTON
SHOTS | EDMONTON
[NAME] | EDMONTON
[NAME] | EDMONTON
[NAME] | EDMONTON
G. T | EDMONTON
GA | EDMONTON
GAA | EDMONTON
SAVES | EDMONTON
SA % | EDMONTON
SO | EDMONTON
PIM | EDMONTON
A | EDMONTON
WINS | EDMONTON
LOSSES | EDMONTON
TIES | EDMONTON
POINTS | EDMONTON
GF | EDMONTON
GA | EDMONTON
[NAME] | EDMONTON
Least Losses | EDMONTON
Least Ties | EDMONTON
Least Points | EDMONTON
Least GF | EDMONTON
Least GA | EDMONTON
G | HARTFORD
A | HARTFORD
P | HARTFORD
PlusMinus | HARTFORD
PIM | HARTFORD
PPG | HARTFORD
SHG | HARTFORD
GWG | HARTFORD
HITS | HARTFORD
SHOTS | HARTFORD
[NAME] | HARTFORD
[NAME] | HARTFORD
[NAME] | HARTFORD
G. T | HARTFORD
GA | HARTFORD
GAA | HARTFORD
SAVES | HARTFORD
SA % | HARTFORD
SO | HARTFORD
PIM | HARTFORD
A | HARTFORD
WINS | HARTFORD
LOSSES | HARTFORD
TIES | HARTFORD
POINTS | HARTFORD
GF | HARTFORD
GA | HARTFORD
[NAME] | HARTFORD
Least Losses | HARTFORD
Least Ties | HARTFORD
Least Points | HARTFORD
Least GF | HARTFORD
Least GA | HARTFORD
G | LAKINGS
A | LAKINGS
P | LAKINGS
PlusMinus | LAKINGS
PIM | LAKINGS
PPG | LAKINGS
SHG | LAKINGS
GWG | LAKINGS
HITS | LAKINGS
SHOTS | LAKINGS
[NAME] | LAKINGS
[NAME] | LAKINGS
[NAME] | LAKINGS
G. T | LAKINGS
GA | LAKINGS
GAA | LAKINGS
SAVES | LAKINGS
SA % | LAKINGS
SO | LAKINGS
PIM | LAKINGS
A | LAKINGS
WINS | LAKINGS
LOSSES | LAKINGS
TIES | LAKINGS
POINTS | LAKINGS
GF | LAKINGS
GA | LAKINGS
[NAME] | LAKINGS
Least Losses | LAKINGS
Least Ties | LAKINGS
Least Points | LAKINGS
Least GF | LAKINGS
Least GA | LAKINGS
G | MINNESOTA
A | MINNESOTA
P | MINNESOTA
PlusMinus | MINNESOTA
PIM | MINNESOTA
PPG | MINNESOTA
SHG | MINNESOTA
GWG | MINNESOTA
HITS | MINNESOTA
SHOTS | MINNESOTA
[NAME] | MINNESOTA
[NAME] | MINNESOTA
[NAME] | MINNESOTA
G. T | MINNESOTA
GA | MINNESOTA
GAA | MINNESOTA
SAVES | MINNESOTA
SA % | MINNESOTA
SO | MINNESOTA
PIM | MINNESOTA
A | MINNESOTA
WINS | MINNESOTA
LOSSES | MINNESOTA
TIES | MINNESOTA
POINTS | MINNESOTA
GF | MINNESOTA
GA | MINNESOTA
[NAME] | MINNESOTA
Least Losses | MINNESOTA
Least Ties | MINNESOTA
Least Points | MINNESOTA
Least GF | MINNESOTA
Least GA | MINNESOTA
G | MONTREAL
A | MONTREAL
P | MONTREAL
PlusMinus | MONTREAL
PIM | MONTREAL
PPG | MONTREAL
SHG | MONTREAL
GWG | MONTREAL
HITS | MONTREAL
SHOTS | MONTREAL
[NAME] | MONTREAL
[NAME] | MONTREAL
[NAME] | MONTREAL
G. T | MONTREAL
GA | MONTREAL
GAA | MONTREAL
SAVES | MONTREAL
SA % | MONTREAL
SO | MONTREAL
PIM | MONTREAL
A | MONTREAL
WINS | MONTREAL
LOSSES | MONTREAL
TIES | MONTREAL
POINTS | MONTREAL
GF | MONTREAL
GA | MONTREAL
[NAME] | MONTREAL
Least Losses | MONTREAL
Least Ties | MONTREAL
Least Points | MONTREAL
Least GF | MONTREAL
Least GA | MONTREAL
G | NEWJERSEY
A | NEWJERSEY
P | NEWJERSEY
PlusMinus | NEWJERSEY
PIM | NEWJERSEY
PPG | NEWJERSEY
SHG | NEWJERSEY
GWG | NEWJERSEY
HITS | NEWJERSEY
SHOTS | NEWJERSEY
[NAME] | NEWJERSEY
[NAME] | NEWJERSEY
[NAME] | NEWJERSEY
G. T | NEWJERSEY
GA | NEWJERSEY
GAA | NEWJERSEY
SAVES | NEWJERSEY
SA % | NEWJERSEY
SO | NEWJERSEY
PIM | NEWJERSEY
A | NEWJERSEY
WINS | NEWJERSEY
LOSSES | NEWJERSEY
TIES | NEWJERSEY
POINTS | NEWJERSEY
GF | NEWJERSEY
GA | NEWJERSEY
[NAME] | NEWJERSEY
Least Losses | NEWJERSEY
Least Ties | NEWJERSEY
Least Points | NEWJERSEY
Least GF | NEWJERSEY
Least GA | NEWJERSEY
G | [NAME]
A | [NAME]
P | [NAME]
PlusMinus | [NAME]
PIM | [NAME]
PPG | [NAME]
SHG | [NAME]
GWG | [NAME]
HITS | [NAME]
SHOTS | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
G. T | [NAME]
GA | [NAME]
GAA | [NAME]
SAVES | [NAME]
SA % | [NAME]
SO | [NAME]
PIM | [NAME]
A | [NAME]
WINS | [NAME]
LOSSES | [NAME]
TIES | [NAME]
POINTS | [NAME]
GF | [NAME]
GA | [NAME]
[NAME] | [NAME]
Least Losses | [NAME]
Least Ties | [NAME]
Least Points | [NAME]
Least GF | [NAME]
Least GA | [NAME]
G | NYRANGERS
A | NYRANGERS
P | NYRANGERS
PlusMinus | NYRANGERS
PIM | NYRANGERS
PPG | NYRANGERS
SHG | NYRANGERS
GWG | NYRANGERS
HITS | NYRANGERS
SHOTS | NYRANGERS
[NAME] | NYRANGERS
[NAME] | NYRANGERS
[NAME] | NYRANGERS
G. T | NYRANGERS
GA | NYRANGERS
GAA | NYRANGERS
SAVES | NYRANGERS
SA % | NYRANGERS
SO | NYRANGERS
PIM | NYRANGERS
A | NYRANGERS
WINS | NYRANGERS
LOSSES | NYRANGERS
TIES | NYRANGERS
POINTS | NYRANGERS
GF | NYRANGERS
GA | NYRANGERS
[NAME] | NYRANGERS
Least Losses | NYRANGERS
Least Ties | NYRANGERS
Least Points | NYRANGERS
Least GF | NYRANGERS
Least GA | NYRANGERS
G | OAKLAND
A | OAKLAND
P | OAKLAND
PlusMinus | OAKLAND
PIM | OAKLAND
PPG | OAKLAND
SHG | OAKLAND
GWG | OAKLAND
HITS | OAKLAND
SHOTS | OAKLAND
[NAME] | OAKLAND
[NAME] | OAKLAND
[NAME] | OAKLAND
G. T | OAKLAND
GA | OAKLAND
GAA | OAKLAND
SAVES | OAKLAND
SA % | OAKLAND
SO | OAKLAND
PIM | OAKLAND
A | OAKLAND
WINS | OAKLAND
LOSSES | OAKLAND
TIES | OAKLAND
POINTS | OAKLAND
GF | OAKLAND
GA | OAKLAND
[NAME] | OAKLAND
Least Losses | OAKLAND
Least Ties | OAKLAND
Least Points | OAKLAND
Least GF | OAKLAND
Least GA | OAKLAND
G | OTTAWA
A | OTTAWA
P | OTTAWA
PlusMinus | OTTAWA
PIM | OTTAWA
PPG | OTTAWA
SHG | OTTAWA
GWG | OTTAWA
HITS | OTTAWA
SHOTS | OTTAWA
[NAME] | OTTAWA
[NAME] | OTTAWA
[NAME] | OTTAWA
G. T | OTTAWA
GA | OTTAWA
GAA | OTTAWA
SAVES | OTTAWA
SA % | OTTAWA
SO | OTTAWA
PIM | OTTAWA
A | OTTAWA
WINS | OTTAWA
LOSSES | OTTAWA
TIES | OTTAWA
POINTS | OTTAWA
GF | OTTAWA
GA | OTTAWA
[NAME] | OTTAWA
Least Losses | OTTAWA
Least Ties | OTTAWA
Least Points | OTTAWA
Least GF | OTTAWA
Least GA | OTTAWA
G | PHILLY
A | PHILLY
P | PHILLY
PlusMinus | PHILLY
PIM | PHILLY
PPG | PHILLY
SHG | PHILLY
GWG | PHILLY
HITS | PHILLY
SHOTS | PHILLY
[NAME] | PHILLY
[NAME] | PHILLY
[NAME] | PHILLY
G. T | PHILLY
GA | PHILLY
GAA | PHILLY
SAVES | PHILLY
SA % | PHILLY
SO | PHILLY
PIM | PHILLY
A | PHILLY
WINS | PHILLY
LOSSES | PHILLY
TIES | PHILLY
POINTS | PHILLY
GF | PHILLY
GA | PHILLY
[NAME] | PHILLY
Least Losses | PHILLY
Least Ties | PHILLY
Least Points | PHILLY
Least GF | PHILLY
Least GA | PHILLY
G | PITTSBURGH
A | PITTSBURGH
P | PITTSBURGH
PlusMinus | PITTSBURGH
PIM | PITTSBURGH
PPG | PITTSBURGH
SHG | PITTSBURGH
GWG | PITTSBURGH
HITS | PITTSBURGH
SHOTS | PITTSBURGH
[NAME] | PITTSBURGH
[NAME] | PITTSBURGH
[NAME] | PITTSBURGH
G. T | PITTSBURGH
GA | PITTSBURGH
GAA | PITTSBURGH
SAVES | PITTSBURGH
SA % | PITTSBURGH
SO | PITTSBURGH
PIM | PITTSBURGH
A | PITTSBURGH
WINS | PITTSBURGH
LOSSES | PITTSBURGH
TIES | PITTSBURGH
POINTS | PITTSBURGH
GF | PITTSBURGH
GA | PITTSBURGH
[NAME] | PITTSBURGH
Least Losses | PITTSBURGH
Least Ties | PITTSBURGH
Least Points | PITTSBURGH
Least GF | PITTSBURGH
Least GA | PITTSBURGH
G | QUEBEC
A | QUEBEC
P | QUEBEC
PlusMinus | QUEBEC
PIM | QUEBEC
PPG | QUEBEC
SHG | QUEBEC
GWG | QUEBEC
HITS | QUEBEC
SHOTS | QUEBEC
[NAME] | QUEBEC
[NAME] | QUEBEC
[NAME] | QUEBEC
G. T | QUEBEC
GA | QUEBEC
GAA | QUEBEC
SAVES | QUEBEC
SA % | QUEBEC
SO | QUEBEC
PIM | QUEBEC
A | QUEBEC
WINS | QUEBEC
LOSSES | QUEBEC
TIES | QUEBEC
POINTS | QUEBEC
GF | QUEBEC
GA | QUEBEC
[NAME] | QUEBEC
Least Losses | QUEBEC
Least Ties | QUEBEC
Least Points | QUEBEC
Least GF | QUEBEC
Least GA | QUEBEC
G | ST.LOUIS
A | ST.LOUIS
P | ST.LOUIS
PlusMinus | ST.LOUIS
PIM | ST.LOUIS
PPG | ST.LOUIS
SHG | ST.LOUIS
GWG | ST.LOUIS
HITS | ST.LOUIS
SHOTS | ST.LOUIS
[NAME] | ST.LOUIS
[NAME] | ST.LOUIS
[NAME] | ST.LOUIS
G. T | ST.LOUIS
GA | ST.LOUIS
GAA | ST.LOUIS
SAVES | ST.LOUIS
SA % | ST.LOUIS
SO | ST.LOUIS
PIM | ST.LOUIS
A | ST.LOUIS
WINS | ST.LOUIS
LOSSES | ST.LOUIS
TIES | ST.LOUIS
POINTS | ST.LOUIS
GF | ST.LOUIS
GA | ST.LOUIS
[NAME] | ST.LOUIS
Least Losses | ST.LOUIS
Least Ties | ST.LOUIS
Least Points | ST.LOUIS
Least GF | ST.LOUIS
Least GA | ST.LOUIS
G | TORONTO
A | TORONTO
P | TORONTO
PlusMinus | TORONTO
PIM | TORONTO
PPG | TORONTO
SHG | TORONTO
GWG | TORONTO
HITS | TORONTO
SHOTS | TORONTO
[NAME] | TORONTO
[NAME] | TORONTO
[NAME] | TORONTO
G. T | TORONTO
GA | TORONTO
GAA | TORONTO
SAVES | TORONTO
SA % | TORONTO
SO | TORONTO
PIM | TORONTO
A | TORONTO
WINS | TORONTO
LOSSES | TORONTO
TIES | TORONTO
POINTS | TORONTO
GF | TORONTO
GA | TORONTO
[NAME] | TORONTO
Least Losses | TORONTO
Least Ties | TORONTO
Least Points | TORONTO
Least GF | TORONTO
Least GA | TORONTO
G | [NAME]
A | [NAME]
P | [NAME]
PlusMinus | [NAME]
PIM | [NAME]
PPG | [NAME]
SHG | [NAME]
GWG | [NAME]
HITS | [NAME]
SHOTS | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
G. T | [NAME]
GA | [NAME]
GAA | [NAME]
SAVES | [NAME]
SA % | [NAME]
SO | [NAME]
PIM | [NAME]
A | [NAME]
WINS | [NAME]
LOSSES | [NAME]
TIES | [NAME]
POINTS | [NAME]
GF | [NAME]
GA | [NAME]
[NAME] | [NAME]
Least Losses | [NAME]
Least Ties | [NAME]
Least Points | [NAME]
Least GF | [NAME]
Least GA | [NAME]
G | WASHINGTON
A | WASHINGTON
P | WASHINGTON
PlusMinus | WASHINGTON
PIM | WASHINGTON
PPG | WASHINGTON
SHG | WASHINGTON
GWG | WASHINGTON
HITS | WASHINGTON
SHOTS | WASHINGTON
[NAME] | WASHINGTON
[NAME] | WASHINGTON
[NAME] | WASHINGTON
G. T | WASHINGTON
GA | WASHINGTON
GAA | WASHINGTON
SAVES | WASHINGTON
SA % | WASHINGTON
SO | WASHINGTON
PIM | WASHINGTON
A | WASHINGTON
WINS | WASHINGTON
LOSSES | WASHINGTON
TIES | WASHINGTON
POINTS | WASHINGTON
GF | WASHINGTON
GA | WASHINGTON
[NAME] | WASHINGTON
Least Losses | WASHINGTON
Least Ties | WASHINGTON
Least Points | WASHINGTON
Least GF | WASHINGTON
Least GA | WASHINGTON
G | WINNIPEG
A | WINNIPEG
P | WINNIPEG
PlusMinus | WINNIPEG
PIM | WINNIPEG
PPG | WINNIPEG
SHG | WINNIPEG
GWG | WINNIPEG
HITS | WINNIPEG
SHOTS | WINNIPEG
[NAME] | WINNIPEG
[NAME] | WINNIPEG
[NAME] | WINNIPEG
G. T | WINNIPEG
GA | WINNIPEG
GAA | WINNIPEG
SAVES | WINNIPEG
SA % | WINNIPEG
SO | WINNIPEG
PIM | WINNIPEG
A | WINNIPEG
WINS | WINNIPEG
LOSSES | WINNIPEG
TIES | WINNIPEG
POINTS | WINNIPEG
GF | WINNIPEG
GA | WINNIPEG
[NAME] | WINNIPEG
Least Losses | WINNIPEG
Least Ties | WINNIPEG
Least Points | WINNIPEG
Least GF | WINNIPEG
Least GA | WINNIPEG