In-Out - Comparison

[suby]

Hi All,

Comparing current month(30-04-2021) and Previous Month (31-03-2021)

On this I'm trying to find three scenarios.

- which ID have carried from Previous month to current month.
- which New ID have come in this current month.
- which IDs where there in Previous month but not present this current month

wanted this to be dynamic so that when more data is added this has to be dynamic to compare current vs previous month.

Attached the sample workflow.

[suby]

Hello T_Willins,

Sorry can i have both of your solution workflow based on my sample Data please.

- comparing just current Month against Previous Month only.

- Evaluate All Data Against Previous and Subsequent Months

Many Thanks

[Emil_Kos]

Hi @suby,

Did you by any chance test my workflow? I was thinking that it should work for you. 

[suby]

Hi Emil_Kos,

I'm looking for a solution where i can get the desired output like this in a single column  using multi row formula.