I have an expense report in Excel, from the Extended totals column (G) for each expense I want to insert a column (H) that has an assignment Letter (A through E). The Next 5 Columns (I - M) are marked A through E as they relate to the different cost centers. How do I create a formula that lets me quickly code each line in Column G (My totals per line) by just inserting the letter A or B or C or D or E into the corresponding line in Column H and that total automatically copies over to the correct Column

In I1:M1 enter your Cost Center letters A - E Assuming your first Extended Total is in G2, enter this formula in I2 (adjust as required)

=IF($H2=I$1,$G2,"")

Drag this over to M2 and then drag I2:M2 down as far as you need.

The key is to ensure you use the dollar signs exactly as shown.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you very much, that worked 100%!!! Thanks again!

Ask Your Question

Weekly Poll