Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Adding Columns in Excel with a Formula

O_
5 - Atom

Hello All!

 

I am trying to make an "IF" statement that will automatically create a new column to the right.  The basis of the if is a change in the month.  So, I would like a new column to appear every month automatically.  Help!

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Do you mean something like this? If not, provide a few extra details if possible and we can help get you to a solution! Workbook attached.

 

DataNath_0-1652897879873.png

 

O_
5 - Atom

Thanks!  I think that should do it!