Excel comparison question
Closed
dare05
Posts
4
Registration date
Monday August 2, 2010
Status
Member
Last seen
August 2, 2010
-
Aug 2, 2010 at 12:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 2, 2010 at 01:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 2, 2010 at 01:35 PM
Related:
- Excel comparison question
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 2, 2010 at 12:51 PM
Aug 2, 2010 at 12:51 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
dare05
Posts
4
Registration date
Monday August 2, 2010
Status
Member
Last seen
August 2, 2010
Aug 2, 2010 at 01:04 PM
Aug 2, 2010 at 01:04 PM
Btw, each column containts 9500+ so it would be cool if there's some more automatic method.
dare05
Posts
4
Registration date
Monday August 2, 2010
Status
Member
Last seen
August 2, 2010
Aug 2, 2010 at 01:09 PM
Aug 2, 2010 at 01:09 PM
Okay here it is:
https://authentification.site/files/23633005/links-page-www.whitepages.com.xlsx
As I've mentioned, each column has 9700+ rows. I've modified cell B27 so it's the only cell in column B that's different that column A.
The script/function should output ONLY that cell in column C because it's the only cell that's in column B and NOT in column A.
Regards
https://authentification.site/files/23633005/links-page-www.whitepages.com.xlsx
As I've mentioned, each column has 9700+ rows. I've modified cell B27 so it's the only cell in column B that's different that column A.
The script/function should output ONLY that cell in column C because it's the only cell that's in column B and NOT in column A.
Regards
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 2, 2010 at 01:18 PM
Aug 2, 2010 at 01:18 PM
all you need is a match function like this
https://ccm.net/forum/affich-438055-matching-2-columns-in-excel#p438092
Only difference being that you want to know when the match is not found (in the solution, when then match is not found "" is displayed)
https://ccm.net/forum/affich-438055-matching-2-columns-in-excel#p438092
Only difference being that you want to know when the match is not found (in the solution, when then match is not found "" is displayed)
dare05
Posts
4
Registration date
Monday August 2, 2010
Status
Member
Last seen
August 2, 2010
Aug 2, 2010 at 01:23 PM
Aug 2, 2010 at 01:23 PM
Man that will work but you must remember that I can't scroll 9000 rows to see values that don't match. I need this in order to get a clean view of values that don't match without the effort of scrolling 9000+ rows and identifying them manually.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 2, 2010 at 01:35 PM
Aug 2, 2010 at 01:35 PM
You dont have to scroll. Copy the formula down (for that you just have enter the formula in the first cell and then double click that black box that appears at the bottom of the cell), apply filter on sheet where column C is not blank and you should see only those rows that has some data
If you still want to bring the rows at the top,
1 copy the formula down
2 select col C and choose copy
3. select pastespecial and paste as values
4. sort only column C.
If you still want to bring the rows at the top,
1 copy the formula down
2 select col C and choose copy
3. select pastespecial and paste as values
4. sort only column C.