Excell populating columns
Budget: £20 – £250 GBP
We get given a xls file with 3 tabs, Lineitems, Line Orders and Totals
We need to populate sheet1 in the following columns
Sheet 1
Column K = 1st 4 digits of sheet LineItems Column E
Column L = characters 5 , 6 and 7 of column E
Column M = Column E followed by “,” followed by Column E if column K and L are the same,
Column N = the number of times the same thing appears in Column E followed by “,” if the there are other sizes.
We need to populate sheet1 in the following columns
Sheet 1
Column K = 1st 4 digits of sheet LineItems Column E
Column L = characters 5 , 6 and 7 of column E
Column M = Column E followed by “,” followed by Column E if column K and L are the same,
Column N = the number of times the same thing appears in Column E followed by “,” if the there are other sizes.