I am wanting excel to split years out into 2 columns

**greggy16121979** · 02-05-2021, 11:35 AM

Cell b2

years in the sheet

2005 , 2006 , 2007 , 2008 , 2009 , 2010 , 2011 , 2012 , 2013 , 2014 , 2015 , 2016 , 2017 , 2018 , 2019 , 2020

cell c2

years in the sheet from to

2005-2020

cell d2

years to include

2006-2009

cell e2

includeyears auto fill

should read 2006 , 2007 , 2008 , 2009

cell f2

excludeyears auto fill

2005 , 2010 , 2011 , 2012 , 2013 , 2014 , 2015 , 2016 , 2017 , 2018 , 2019 , 2020

**Pepe Le Mokko** · 02-05-2021, 11:42 AM

Hi
could you be a little more explicit please?

**Croweater** · 02-06-2021, 10:08 PM

This VBA sub should give you roughly what you need...

Please Login or Register  to view this content.

**Bo_Ry** · 02-07-2021, 02:17 AM

Please try at
E2
=MID(LEFT(B2,IFERROR(FIND(RIGHT(C2,4),B2)+3,999)),IFERROR(FIND(LEFT(C2,4),B2),1),999)

F2
=SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(B2,E2,),",",))," "," , ")

I am wanting excel to split years out into 2 columns

LinkBack

Thread Tools

Rate This Thread

Display

I am wanting excel to split years out into 2 columns

Re: I am wanting excel to split years out into 2 columns

Re: I am wanting excel to split years out into 2 columns

Re: I am wanting excel to split years out into 2 columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Split years into weeks and get a date

Wanting to split one cell into multiple rows while keeping data next to it

Split number of months from years

Split Start End date into multiple years

[SOLVED] Wanting to do SUMIF across multiple columns

[SOLVED] [SOLVED] Overlay 4 years of data as a line on 4 years of columns for several x catego

wanting to know width of several columns for copying

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions