Random team generator
#Random team generator android#
The formula returns errors when all teams are populated, the IFERROR function converts the errors into a given value, in this case "-". Your good team will be Vegito with an A Assist, SSJ Goku with B Assist, and Android 21 with C Assist. The INDEX function returns a value based on a cell reference and column/row numbers. 0 (zero) indicates values that not yet have been displayed.ĬOUNTIF("Team", )))Īnd returns 2.
This makes the formula aware of values displayed in cells above.Football Manager Random Team Generator
output