Using IF formula for Reporting

[Fleggy]

Hi all
I need to create a report that tells me if a user was able to authenticate or not based on 12 months worth of auth records I have downloaded.
The two columns I am interested in are
TR_USERID
TR_RESULT

Basically what I want to do is
For each row in TR_USERID, check TR_RESULT.
If TR_RESULT = accept, then give me an output of 1 in column TR_ID
If TR_RESULT = reject then give me an output of 0 in column TR_ID

I then need to collate the data to see if any user has had an reject and then subsequently got an accept or if they started with a reject and kept getting rejects.
Thanks in advance

 

[NARAYANK991]

Hi ,

The first part of what you want to do can be done using a simple IF function ; the second part is not clear ; can you upload a sample workbook with adequate data ?

Narayan

 

[Fleggy]

I have created a new file - obviously I cannot upload a real file but the info is all there

For the second part, as you can see from the file, User 1 always got accepts, User 2 always got rejects and User 3 first got a reject but then got an accept.

I want to be able to show a report that shows
User 1 always worked
User 2 always failed
User 3 failed then worked
Thanks
Adam

 

[NARAYANK991]

Hi Adam ,

See the file.

Narayan

 

[Fleggy]

Thanks Narayan
The only issue I have is it is not giving me the expected outcome - not sure if it is because the usernames are not just 1,2,3 etc.
I have uploaded another file with the actual data - appreciate any help you can give

 

[NARAYANK991]

Hi Adam ,

I forgot to mention it , but all your data in column B has a leading space character ; I had removed it.

Narayan