| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Identifying exact values in alternate rows
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
