Identify two or more are same or not in Excel

Solved/Closed
SatGod - Mar 31, 2010 at 01:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 2, 2010 at 10:01 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 2, 2010 at 10:01 PM
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