I'm a novice to Excel and using formulas.
I'm doing a league format with 4 divisions.
I've got a list of players in column b and the chosen division in column c.
What formula can i use to automatically put the names into the respaective
divisions without have to copy / retype all the names each time.
DGET or an =IF rule ? I've tried loads but get nothing to transfer.

Help Please