You are reading a single comment by @Dogtemple and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
duncs
@Dogtemple
Hi
I’ve been trying to figure this out asking on google but don’t think I’m using the correct terms.
Basically I have a spreadsheet, I need two columns with the team in one and the manager in the next column.
I have used conditional formatting, so I put in 1 and it automatically makes that show as ‘team 1’ when you press enter.
I would like it to automatically add the mangers name in the field next to it when you enter the team number.
there are 16 teams, 16 managers.
Anyone have any ideas on what to do here please? I’m a bit novice on spreadsheets