Referencing values in the same column

[Anonymous]

Greetings, 

Bit of a newbie here. 

Have a table with multiple usernames and some of the accounts have an "@" symbol in the end in the same column, to indicate that the account is closed. Yet if the same person comes back to the company later, a new account is created with the same username, but without the "@". I need to think of a formula to search if there are same usernames ignoring the "@" symbol, but if all of the same username have "@" in the ending, to return the value with the "@" in the end. Data is quite sensitive, as such I am unable to share it. Any sugestions how I should do that? Have already figured out to find usernames that have the @ symbol with "

if(SEARCH("@",User[Username],1,0)>0,"True","False")". But once again, this will show a user that they are not working, even though there is another account with the same username just without the "@"

Hopefully that provides some clarity.

Best regards

[Anonymous]

So a bit of an update is required: Using the formula I was able to filter out the newest one, mark it as latest, thought that it was all complete and was happy, but apparantly in some rare cases, newest accounts are not the active ones. 

So the fields I have are:
[Active] (shows if the account is active),
[number value] (shows the number value of the account, the larger the number, the later it was created),

[Initials] (username)
[Username] (Full name of the user using it)

So the formula I ended up on is 

if( maxx(filter(User, [Username] = earlier([Username])), [number_value])  = [number_value], "Latest", "Old")

But I need it to take in the fact that it finds the most recent Active one, so the Active column must be True as well. How do i add the 

FILTER(User,User[Active]="True") into the formula?

[amitchandak]

@Anonymous , You need mark the latest rescord for the person based on email or name and check that row only

lastest a new column

= if( maxx(filter(Table, [Name] = earlier([Name])), [Date])  = [Date], "Latest", "Old")

[Anonymous]

Greetings, Date is not a column in the table. There is though a employee number value that gets assigned to a username, the latest ones are most likely the active one. I tried adapting the formula you wrote but it gave out is marking the latest disabled username and the active username as the latest. Where both of the disabled ones need to be shown as old, and the active ones need to be the latest. In other words. If the is a Username TEST and TEST@ all instances of TEST@ need to be marked as old and there will only be one TEST and there can't be multiples of the same name.