Hey!
I'm new to this but I have a problem I would really appreciate getting help with.
I have a worksheet with over 1000 rows, with a column containing a bunch of names of different projects. Each project can appear several times, since they have changed status over the years. There is a date column, and a status column varying from "Idea", "Project", "Company" and "Archive". So project "A" for example can appear four times if they have gone through all these stages. And to make it complicated there is an Archive ID column with numbers ranging from 0-3. 0 meaning the project is closed, 1 meaning the project has continued externally, 2 meaning the project is on hold, 3 meaning the project is active. So if a project has the status "Archive" a given date you need to chech the "Arhive ID" to get more information on the status. If the project has one of the other statuses the "Archive ID" number means nothing.
I hope this is not to confusing. My problem here is that I want to know how many ideas have been ended, i.e. I want to count all the projects who only occur two times, first with the status "Idea" and then "Archive" with ID 0. I would actually like to count several combinations, for example idea to project, and project to archive 1,2,3,0. It would be easier to count how many have gone from idea to project since that eliminates the search through the "Archive ID" column, but I guess the solution would be similar.
So does anybody think they can help? Is it possible to do this without writing a code?
I really appreciate the help!
/M
Bookmarks