(complicated formula for me) Whoever wants to help, the details are inside

[chosen]

I have duplicate names in column A in Excel I want to output FALSE on the first set of duplicate names, then TRUE on the next set of duplicate names, then FALSE on the next set of names, and so on. Sometimes there are no duplicate names, however I want when I change any name it changes from FALSE to TRUE or from TRUE to FALSE
Here is an example I made manually
Emely
Ashly
James
Robert
Robert
Robert
Michael
Michael
David
Richard
James
James
I want it as follows
Ashly TRUE
James FALSE
Robert TRUE
Robert TRUE
Robert TRUE
Michael FALSE
Michael FALSE
David TRUE
Richard FALSE
James TRUE
James TRUE

I want these results for conditional formatting
To color each person individually
Thank you very much

 

[Fluff]

In that example you have James on the 3rd line & also at the bottom. Is that how your data is, or will all names be together?

 

[chosen]

just wrong
All names together

 

[chosen]

I am very sorry for the mistake
This is the example I made manually
Emely
Ashly
Robert
Robert
Robert
Michael
Michael
David
Richard
James
James

I want it as follows

Ashly TRUE
Robert FALSE
Robert FALSE
Robert FALSE
Michael TRUE
Michael TRUE
David FALSE
Richard TRUE
James FALSE
James FALSE

 

[chosen]

Is this equation impossible to solve?
Or does she have an effortless solution?

 

[awoohaw]

How about this:
It is leaving Emely in, though.

Book2
	A	B
1	Emely	TRUE
2	Ashly	FALSE
3	Robert	TRUE
4	Robert	TRUE
5	Robert	TRUE
6	Michael	FALSE
7	Michael	FALSE
8	David	TRUE
9	Richard	FALSE
10	James	TRUE
11	James	TRUE
Sheet8

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2<>A1,IF(B1=TRUE,FALSE,TRUE),IF(B1=TRUE,TRUE,FALSE))

 

[chosen]

How about this:
It is leaving Emely in, though.

Book2
	A	B
1	Emely	TRUE
2	Ashly	FALSE
3	Robert	TRUE
4	Robert	TRUE
5	Robert	TRUE
6	Michael	FALSE
7	Michael	FALSE
8	David	TRUE
9	Richard	FALSE
10	James	TRUE
11	James	TRUE
Sheet8

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2<>A1,IF(B1=TRUE,FALSE,TRUE),IF(B1=TRUE,TRUE,FALSE))

Thank you very very much

 

[veyselemre]

B2 formula, alternative;

=IF(A2=A1,B1,NOT(B1))

 

[chosen]

B2 formula, alternative;

=IF(A2=A1,B1,NOT(B1))

Thank you very much my dear brother

شكرا جزيلا جدا اخي الكريم
من كثرت ما شفت الجواب بسيط حسيت انه انا ضعيف جدا بالاكسل
والحقيقة انه انا في طريقة الحل عقدت المعادلات وما بسطتها
الف شكر لك اخي الكريم

 

[chosen]

B2 formula, alternative;

=IF(A2=A1,B1,NOT(B1))

المصنف1
	B
2	TRUE
ورقة1

Cell Formulas
Range	Formula
B2	B2	=IF(A2=A1,B1,NOT(B1))

المشكلة انه B1 ليست فارغة عندي
هل هناك حل ؟