Identify two or more are same or not in Excel

Solved/Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi Everyone,
I have an excel formula question that someone might can help me with.

A B
1 <- A1 True
1 <- A2 True
1 <- A3 True
4 <- A4 False
2 <- A5 True
2 <- A6 True

Using IF command, how would I show that above data to identify the same datas and returns me with message showing true or false on column B?
As you see above, A1, A2, A3 are same with data 1 and A5 and A6 are same with data 2.
I need to have compare between different rows, row before and row after and if any of the data is same then the returning value on B would be true.
If row before or after doesn't contain same data then the returning value on B would be false.
I hope my question is not too confusing.
Thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
you have 6 rows of dta . I have added one more 2 in the 7 th row in A7 for experimental sake

bcause you are talking about nefore and after you can get formulas only from row 2 to row 6

i B2 copy this formula

=IF(AND(A2=A1,A2=A3),"True","false")

dcopy B2 down till B6 only)
see column B . is it ok
0