|
Re: Scouting using Excel, please help
If you're opposed to using VBA or not super familiar with excel functions, I'd recommend a lookup column that tells you if a certain team number is in that row. Try iferror(match(cell,array,0),""). PM me and I can walk you through some fancier excel stuff. We scouted with excel in '14 and I was happy with the results, I can send you that sheet.
__________________
Mike Schreiber
Kettering University ('09-'13) University of Michigan ('14-'18?)
FLL ('01-'02), FRC Team 27 ('06-'09), Team 397 ('10), Team 3450/314 ('11), Team 67 ('14-'??)
|