compare column

  • Thread starter Thread starter nishkrish
  • Start date Start date
N

nishkrish

is there a built in program in excel which i can use to compare column a of
one worksheet to column b of another worksheet
 
You can use a formula like this:

=isnumber(match(a1,sheet2!b:b,0))
to return True if the value in A1 matches any of the values in column B of
sheet2. It'll return False if there is no match.

=a1=sheet2!b1
will compare two cells

Not sure what you wanted.
 
No both formulas give out false value i have same numbers in two different
work sheet what i want is it should check if sheet 1 column a10 matches the
same number in sheet 2 at column aa23 basically it should match the number
like

Sheet 1

column A

3000111009806550
3000111009106790
3000111109862360
3000110909152070

The same number are avaiable in sheet2 but dont know what row number
 
Either there is a difference in the characters that make up those entries. Or
one of the values is text even though it's comprised of all digits.

You can test by picking out the two cells that you know are the same.

Then use:
=a10='sheet2'!aa23

If that's false, then try this in two more empty cells:

=isnumber(a10)
and
=isnumber('sheet2'!aa23

If one of those is true and the other is false, then you can either change the
formula or fix the data.
No both formulas give out false value i have same numbers in two different
work sheet what i want is it should check if sheet 1 column a10 matches the
same number in sheet 2 at column aa23 basically it should match the number
like

Sheet 1

column A

3000111009806550
3000111009106790
3000111109862360
3000110909152070

The same number are avaiable in sheet2 but dont know what row number
Click to expand...
 
i tried both both shows false, i am matching my cell 1 to cell of sheet2
cause i dont know in what cell that number is located in sheet 2 column will
be aa but cell not sure.
 
Do it manually. Find two cells that match. Then try the comparison formulas.

If you can't find a match manually, why do you think that there is a match?


i tried both both shows false, i am matching my cell 1 to cell of sheet2
cause i dont know in what cell that number is located in sheet 2 column will
be aa but cell not sure.
Click to expand...
 
Manually it is there but i am suppose to ck one by one for the whole month so
i was trying to find easy way out.
 
What happened when you tried those formulas against the two cells that appeared
to be the same?

I'm guessing that they are not the same. They only look like it to your eyes.
Excel doesn't see them the same.

Either that or you made a mistake in your formulas. You never shared what you
used.
Manually it is there but i am suppose to ck one by one for the whole month so
i was trying to find easy way out.
--
Nisha P

Dave Peterson said:
Do it manually. Find two cells that match. Then try the comparison formulas.

If you can't find a match manually, why do you think that there is a match?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
compare all data in one worksheet to another 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Newbie Questions 3
One partial table, one master table - update the partial 3
Compare data from two different worksheets with a condition 2
Compare 2 worksheets 1
Excel Comparing two columns 1

Back
Top