Excel - Need of formula's to split up lines into different sheets (there is more then 1 criteria)
Posted on 2014-11-11
I'm quite new to Excel and need to make a complex workbook with some formula's.
I have a lot of lines which i need to split up into to different sheets, so in that case i need to categorize the lines one by one and for that i have made a column where i will choose if its Letter A1, Letter A2, Letter B1 or Letter B2, from that i want it to give me a specific text string that i would be able to use vlookup on.
i hope this make sense else please ask :)
thanks in advance