So I have a list of names in a column in excel. The names are duplicated many times in the data. I want to create a new column that will put a 1 for each time a name first appears and 0’s after that. My goal is to have this column be a distinct count of people. So
Shelly 1
Shelly 0
Adam 1
Shelly 0
Adam 0
Chris 1
Chris 0
Thanks all!
Tired doing some sort of IF statement but I’m lost and can’t achieve it.
New contributor
Jesse Y is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.