Identifying exact values in alternate rows

Y

YG

I would like to find a logical result of comparing two text values on
subsequent rows. I tried using the exact function but cannot copy it for
every row since I dont want it to compare rows 2 and 3. Just 1 and 2, 3 and
4, 5 and 6 etc.. see below example. I have a 1500 rows and identifying which
row to paste the EXACT function is defeating the purpose.
Is there a way to put some logic in the EXACT function so that it compares
rows 1 and 2, 3 and 4, 5 and 6 ..etc.
Hope you guys understand what i need.

Thank you!
Yg.


Katz Warren
Katz Warren
McKenney James
McKenney James
Yellin Albert
Yellin Albert
Green Stephen
Green Stephen
Block Stanley
Block Stanley
Steigbigel Roy
Steigbigel Roy
 
K

Ken Wright

In B1:-

=IF(MOD(ROW(),2)=0,"",A1=A2)

and copy down. This will populate alternate cells with a TRUE or FALSE answer
depending on whether that odd row starting row 1 equals the following even row
(ie row 2), then row 3 = row 4 etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Exact(or other) function for alternate rows? 2
How can I count deviations between two rows? 4
Alternate row comparison 11
Return Column Header from an Index/array, finding Large with a userinput date 0
Formula for multiple rows of same value... 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Change row colors based on a cell value 1
Dynamically sized table compiled from unsorted rows with blank entries 2

Top