how to Match
Hi could you tellme i have some data in Sheet1 and sheet2 both sheet have
some same names and numbers how can i find out? |
how to Match
It really depends on how your data is laid out and what you want to compare.
If I'm trying to find out if a single cell's value is in column A of a different sheet, I'd use a formula in an adjacent cell: =isnumber(match(a1,sheet2!a:a,0)) It'll return True if it's there, false if it's missing. If I wanted to check the value of two cells in the same row against two columns in the other sheet, I'd create a new column on both sheets that joins the columns together and then use the =isnumber(match()) formula: I'd insert a new column and use a formula like: =b1&"--"&c1 and drag down On both sheets. Then use this for the comparison. Rohinikumar wrote: Hi could you tellme i have some data in Sheet1 and sheet2 both sheet have some same names and numbers how can i find out? -- Dave Peterson |
All times are GMT +1. The time now is 04:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com