Hello,

Is there a way to find duplicate user id's from a single column based on the values of two other columns?

Example:

col1 = userid

col2 = Table Name

col 3 - record id

What I want to do is create a colum called Userid2

A formula or something like this:

IF Table Name = PM10000 find the same Userid where table name = PM20000 and return the user id where the table = PM 20000

I am trying to create an audit report that shows IF the same user entered a transaction and Posted it I could Identify the record.