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
Solved! Go to 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.
Thank you this will work