Formula

Question

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 Answer

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.