how do I return non-matching entries from a range of cells
I need to identify differences in adjacent row entries. For example data in row A1:H1 should match exactly data in the adjacent row, A2:H2 and data in A2:H2 should match exactly with data in A3:H3, and data in A3:H3 should match exactly with data in A4:H4, and so on. I really need to identify those that do not match exactly. I have 7000 rows to compare.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
LibreOffice
LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.
523
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER