Formula

[jlfromm]

I have a set of data that have the same Recip ID for month 1, 2, 3.   I want to create a formula that will just select the newest inform from that recip if. 

Example If Recp id -001A has inform for month a 1 and 2 then i want the infor on the from month 2 

               IF Recp ID - 002B has information for month 1, 2, and 3 then I want information on month 3

[Felipe_Ribeir0 · Accepted solution]

Hi @jlfromm 

It would be better to see the exact table for input/output.

If your input is like this:

Then the attached workflow will do the job.

If it is not, please paste/attach your input/expected output here.

[jlfromm]

Thank you this will work