Hey Guys,
I'm trying to split some rows in excel based on what category their expenditure falls into. I have Col 1 with a list of job numbers and Col 2, 3 are different types of expense such as artwork, creative, data, and so on.
What I want to do is use a function that will let me split the jobs into what type of cost they were. For example if one job is creative and one job is equipment I wish to have tables with them all listed in. There are hundreds of jobs and I don't want to sift through them all.
I have tried to use VLOOKUP but can't seem to get it to work. Anyone able to provide some life saving answers?
I'm trying to split some rows in excel based on what category their expenditure falls into. I have Col 1 with a list of job numbers and Col 2, 3 are different types of expense such as artwork, creative, data, and so on.
What I want to do is use a function that will let me split the jobs into what type of cost they were. For example if one job is creative and one job is equipment I wish to have tables with them all listed in. There are hundreds of jobs and I don't want to sift through them all.
I have tried to use VLOOKUP but can't seem to get it to work. Anyone able to provide some life saving answers?