Data Manipulation/formula

[Louiseellis]

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

 

[kweaver]

Welcome to Mr. Excel. It would help if you used XL2BB and show an example.

 

[Louiseellis]

Welcome to Mr. Excel. It would help if you used XL2BB and show an example.

I tried to upload an image but it was too big? How do I send an example? Thank you for your reply.

 

[kweaver]

You an download the XL2BB add-in here: https://www.mrexcel.com/board/excel-articles/xl2bb-excel-range-to-bbcode.1/download

 

[Louiseellis]

You an download the XL2BB add-in here: https://www.mrexcel.com/board/excel-articles/xl2bb-excel-range-to-bbcode.1/download