If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
compare column
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 -- Nisha P |
#2
|
|||
|
|||
compare column
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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson |
#3
|
|||
|
|||
compare column
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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson |
#4
|
|||
|
|||
compare column
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. nishkrish wrote: 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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
compare column
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. -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
compare column
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? nishkrish wrote: 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. -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
compare column
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" wrote: 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? nishkrish wrote: 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. -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
compare column
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. nishkrish wrote: 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" wrote: 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? nishkrish wrote: 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. -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P "Dave Peterson" wrote: 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. nishkrish wrote: 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 -- Nisha P -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|