Previous Topic Next Topic

Please asist

Closed
swathi - Jun 7, 2010 at 02:28 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 07:57 AM
Hello,



I am looking for the values that are in column A and not IN columnB. Also column C should return the values that are in Column A and not in Column B. Can someone advise here.
Related:
  • Please asist
  • Support asist - Download - Cleaning and optimization

2 responses

Answer 1 / 2
swathi
Jun 7, 2010 at 02:33 PM
The below is for excel
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 7, 2010 at 04:55 PM
in C enter the formula


=IF(isError(MATCH(A1, B:B,0)), A1, "")
0
swathi
Jun 8, 2010 at 07:48 AM
Hey I am looking for the value something like column C. Please find the below example. The values must return in columnC

ColumnA ColumnB ColumnC
11 12 11
123 1234 1222
1222 123 11111
11111 2222222
123456 123456
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 8, 2010 at 07:57 AM
No idea what you just asked.

Could you please upload a sample file with sample data 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
0