Previous Topic Next Topic

Please asist

Closed
swathi - Jun 7, 2010 at 02:28 PM
rizvisa1
Posts
4479
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:

2 replies

Answer 1 / 2
swathi
Jun 7, 2010 at 02:33 PM
The below is for excel
0
Answer 2 / 2
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
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