Avatar of wcody
wcody
Flag 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.
Book11a.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
wcody

8/22/2022 - Mon
Dhiraj Mutha

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:

=YEAR(B6)
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.

Thanks
Rob H
wcody

ASKER
Yes assume the start date is 2006 for all students
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
wcody

ASKER
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
Rob Henson

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.

Thanks
Rob H
ASKER CERTIFIED SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
wcody

ASKER
Awesome thanks a bunch!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.