Replacing Unadjusted Values with Adjusted Values

[Rcoleman2585]

Hello,

I am currently importing data from two separate sources on a monthly basis, one includes unadjusted values and the other includes adjusted values. I'm trying to create a filter based on the Month column so that when a current month's adjusted values come in it automatically filters out/excludes the rows for the unadjusted values. Right now I have the data source linked to the adjusted values showing the month as 'X Adj' so that when say January adjusted values are posted the month for those shows as 'Jan Adj'.

I need some type of condition for formula for if the column month includes 'Jan Adj' then 'Jan' is automatically excluded, and the same the next month in February. What is the best way to do this? Thanks!

[Rcoleman2585]

Hello, I actually found a better solution... please see attached workflow. Thanks