Hi
Can anyone help with a formula please.
In column J I have a list of users. In column W I would like a formula which would place a “1” in the cell if the user is unique and zero if not.
Can anyone help please?
Paul
Hi
Can anyone help with a formula please.
In column J I have a list of users. In column W I would like a formula which would place a “1” in the cell if the user is unique and zero if not.
Can anyone help please?
Paul
try
=IF(COUNTIFS($J$4:$J$25924,J4)>1,0,1) and drag down!!!
Last edited by shukla.ankur281190; 08-24-2016 at 08:34 AM. Reason: Missing info
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Here:
Formula:Please Login or Register to view this content.
Or ...
=--(COUNTIF($J$4:J4,J4)=1)
i have the same question
Hi
None of these worked but I managed to adapt one slightly to make it work, =IF(COUNTIF($J$4:$J4, J4)=1, 1, 0)
It's a solution that Phuocam in post #4 so his should work.
I would rather suggest you next time: instead of thousand examples of input and none of output to create several input values and desired output values.
That will bring you solution faster.
Ah so it was!
Will do - I normally do but will take your recommendation on board for next time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks