Hi All
I am looking for a better worksheet function for this. The data in BP74 and upwards should start in a new column (BN80)
I am looking for a better worksheet function for this. The data in BP74 and upwards should start in a new column (BN80)
Excel Workbook | ||||||
---|---|---|---|---|---|---|
BM | BN | BO | BP | |||
70 | 82 | 82 | 81 | 81 | ||
71 | w2-82-10 | DLM501T-O/B | w2-81-10 | DLM501T-O/B | ||
72 | w2-82-9 | DLM501T-O/B | w2-81-9 | DLM501T-O/B | ||
73 | w2-82-8 | DLM501T-O/B | w2-81-8 | DLM501T-O/B | ||
74 | w2-82-7 | DLM501T-O/B | w2-81-7 | DLM501T-O/B | ||
75 | w2-82-6 | DLM501T-O/B | w2-81-6 | BMN23BD | ||
76 | w2-82-5 | DLM501T-O/B | w2-81-5 | AMF40AT | ||
77 | w2-82-4 | DLM501T-O/B | w2-81-4 | PTL311T | ||
78 | w2-82-3 | DLM501T-O/B | w2-81-3 | PTL311T | ||
79 | w2-82-2 | DLM501T-O/B | w2-81-2 | MNP20YT | ||
80 | w2-82-1 | DLM501T-O/B | w2-81-1 | MNP20YT | ||
data1 |