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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 2, 2010 at 10:01 PM
Related:
- Identify two or more are same or not in Excel
- The system could not identify your location viber - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
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
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
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