Autofill year for data transformation

Hello, kindly help me on what formula to use to autofill in years (having a data for start and end year)
or any tricks to make it autofill without dragging.


I want to do this, from
autofill 1.PNG

to
autofill 2.PNG

Thank you so much. Appreciate the help.

Originally Posted by Glenn Kennedy

Next time, please attach a sample sheet (see yellow banner at top of page). This time, your sitiuation was easy to reproduce:

=INDEX($A$2:$A$6,MATCH(0,INDEX(--(COUNTIF($F$1:F1,$A$2:$A$6)=1+$C$2:$C$6-$B$2:$B$6),0),0))&""

and

=IF(F2="","",IF(F1=F2,G1+1,VLOOKUP(F2,$A$2:$B$6,2,FALSE)))

see attachment for layout.

I did attach a sample sheet from the start fyi sir

Thank you for this sir. This is the only way right?

bit of a novice and also on a mac, i hope the xlsx is good.

this is the local legion membership list, columns J and K show branch and club joining date ( should be same but can differ )

I want to upload data to epos to give current members 10% off beer ( good hey )

How do i alter "J" from 11/02/1994 to 11/02/2020

then column "K" to be expiry date 12 months on 11/02/2021

will do, some forums like similar questions to be kept close as one.

Originally Posted by suffolk cabby

bit of a novice and also on a mac, i hope the xlsx is good.

I see you are already aware of this but just for the record see the info below.

If you post a similar but different question in the same thread then everybody gets criss-crossed about which answer applies to which thread and hilarity ensues. We don't mind a direct follow-up question to a solution posted for the original question, but otherwise keeping each question in its own thread avoids confusion. I do suggest you take the time to review all our rules. There aren't many, and they are all important.


Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread