Link to home
Start Free TrialLog in
Avatar of wcody
wcodyFlag for United States of America

asked on

adding rows with new data

Currently i am going through this sheet and inserting rows for however many years are between the year in Column c and the exit year.  Every row in orange is what I have manually added to this sheet for each ID.  I am hoping there is a script or something that can be written so I don't have to add all these rows and years, you should be able to see what I am trying to accomplish by looking at the orange rows i stopped doing the manual inserts at row 144.
Avatar of Dhiraj Mutha
Dhiraj Mutha
Flag of United States of America image

You just need to pull out the year from column B and put that in Column C, correct me if I am wroing?

In that scenrio you can use this formula:

Avatar of Rob Henson
Based on previous question, you did not answer the question posed as to identify the start year for each student.

With the sample data, do we assume for all students the start date was 2006?

If so it is possible to identify how many additional rows are required and populate them accordingly.

Rob H
Avatar of wcody


Yes assume the start date is 2006 for all students
Avatar of wcody


I really have no idea how to identify how many additional rows need to be added outside of continuing to plug along inserting them manually
Finish Year less 2006 (+1) will give number of rows in total required.

EG if finish year is 2009:
  2009 - 2006 + 1 = 4 (2009,08,07,06)

Will also need comparison for subsequent rows where change of program to ensure don't add multiple rows for multiple programs. Likewise check for missing years between programs if that is possible.

I will take another look later.

Rob H
Avatar of als315
Flag of Russian Federation image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wcody


Awesome thanks a bunch!