Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use of Exact(or other) function for alternate rows?
I would like to compare the rows 1 and 2 (names) and have a logical value
returned. Is there a way to do this so that it compares only row 1 and 2, 3 and 4 and not 2 and 3... I have 1500 rows of the names and I would like see which rows have the exact names and which dont. Please guide. Thanks Kat Warren Kat Warren McKenney James McKenney James Yelli Albert Yelli Albert Green Stephen Green Stephen Block Stanley Block Stanley Steigbigel Roy Steigbigel Roy |
#2
|
|||
|
|||
Try this to get the exact. Change "e" to suit your column
Sub comparerows() For i = Cells(Rows.Count, "e").End(xlUp).Row To 1 Step -1 If Cells(i, "e") = Cells(i + 1, "e") Then MsgBox Cells(i + 1, "e").Row Next End Sub -- Don Guillett SalesAid Software "yusee_ygs" wrote in message ... I would like to compare the rows 1 and 2 (names) and have a logical value returned. Is there a way to do this so that it compares only row 1 and 2, 3 and 4 and not 2 and 3... I have 1500 rows of the names and I would like see which rows have the exact names and which dont. Please guide. Thanks Kat Warren Kat Warren McKenney James McKenney James Yelli Albert Yelli Albert Green Stephen Green Stephen Block Stanley Block Stanley Steigbigel Roy Steigbigel Roy |
#3
|
|||
|
|||
Assuming your values start ar row # 2 (even numbered) use this formula
=IF(MOD(ROW(),2)=0,A2=A3,A1=A2) and fill it down "yusee_ygs" wrote in message ... I would like to compare the rows 1 and 2 (names) and have a logical value returned. Is there a way to do this so that it compares only row 1 and 2, 3 and 4 and not 2 and 3... I have 1500 rows of the names and I would like see which rows have the exact names and which dont. Please guide. Thanks Kat Warren Kat Warren McKenney James McKenney James Yelli Albert Yelli Albert Green Stephen Green Stephen Block Stanley Block Stanley Steigbigel Roy Steigbigel Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |