Compare two excel sheet
Closed
sam609
-
Dec 9, 2011 at 01:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 9, 2011 at 05:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 9, 2011 at 05:57 AM
Related:
- Compare two excel sheet
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- How to screenshot excel sheet - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 9, 2011 at 05:57 AM
Dec 9, 2011 at 05:57 AM
and what makes a row unique ? are you saying for a row to be unique, each cell on the row is to be different ?
If that is the case, create a temp column in each sheet. and combine all cells on the row into one by formula (some like =A1 & "|" & b1 & "|" & c1
copy this column into a new sheet. append to same column from the other sheet
use filter, advance filter and obtain the unique values
use data text-to-column to split on "|"
If that is the case, create a temp column in each sheet. and combine all cells on the row into one by formula (some like =A1 & "|" & b1 & "|" & c1
copy this column into a new sheet. append to same column from the other sheet
use filter, advance filter and obtain the unique values
use data text-to-column to split on "|"
