Louiseellis
New Member
- Joined
- Nov 25, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi, I need to work out how to come up with a formula that will code columns o-z to the correct cost centre. E.g. if column p is greater than 0 then it will be 206 but if column q is greater than 0 it will be 209 etc. Also if more than one of the lines has a value in it is there anyway I can get excel to enter another line and show the separate cost centre numbers? Thanks