Mjy Excel main 2 sheets ko compare krna hy k in main kiya data change huwe hy.......ise tarha kinldy mjy 2 columns ko b compare krny ka tareekha bta dain ....
Mjy Excel main 2 sheets ko compare krna hy k in main kiya data change huwe hy.......ise tarha kinldy mjy 2 columns ko b compare krny ka tareekha bta dain ....
for example aap sheet A1:G12. ko compare karna chahti hein.,,
In cell A1 of a third worksheet, enter the following formula:
=IF(Sheet1!A1<>Sheet1!A1,"Different","")
Copy the formula from A1 into all the other cells that represent the range you want to compare. For instance, if you want to compare A1:G12 in both worksheets, then you would copy the formula from A1 into the full range of A1:G12.
A simple way to this is to put in cell D1 of Sheet1 the formula:
=NOT(ISERROR(MATCH(A1,Sheet2!A:A,0)))
This formula will return TRUE if the title in cell A1 of Sheet1 exists anywhere in Col A of Sheet2, and FALSE if it doesn't. You can copy this formula down col D, and the TRUE/FALSEs will indicate which rows of info on Sheet1 are for titles that are on the Sheet2.
Then you can sort by this TRUE/FALSE column, and copy/paste the TRUEs to Sheet3.
1. Open the two workbooks you want to compare.
Display the worksheet in each workbook that you want to compare side by side.
2. Click the View Side by Side button in the Window group of the View tab.
If you have more than two windows open when you click the View Side by Side command button, Excel opens the Compare Side by Side dialog box, where you click the name of the window that you want to compare with the one that’s currently active and click OK.
3. Scroll down or across a worksheet.
Both worksheets scroll together because the Synchronous Scrolling setting is enabled by default when you click the View Side by Side button.
4. (Optional) Click the Synchronous Scrolling button in the Window group if you want to turn off simultaneous scrolling.
Turning off simultaneous scrolling allows you to scroll through one worksheet without the other one scrolling, too.
5. (Optional) Click the Reset Window Position button if you want to reset the window positions of the two workbooks after resizing one or both windows
You might have re sized a window to get a better look at some data.
6. When you’re done comparing the worksheets, click the View Side by Side button in the Window group again.
Excel returns to Normal view.
aap ka masla hal howa kia?
well brother =if(iserror wala formula mjy duplication ka bta raha hy main find krna chah raha hn k jo new data(mean rows main)add huwa hy sirf vo find kr sakon
Friends come up with the solution,its the most common problem.....i m waiting....
AOA,
As per your PM, Keya aap dono columns me se unique data chahte hain ke dono columns me jo duplicate na ho. for example
A B C (Result)
1 3 1
2 4 2
3 5 3
' ' 4
' ' 5
if possible please provide screen shot with your desire result
thanks & regards
main aap k liay excel file attach kr raha hn..for simplicity i just kept simple data in two columns but remember it could be text or numeric
see the attached file.
Kindly aap formula samjha do is sy sb ka problem one time solve ho jy ga.....coz agar is kee logic samjh aa gayee to usko use krny main problem nahin hoti....another thing k main third column main non duplicated data daikhna chahta hn ok....again attaching modified sheet for you...
salam::
may be i'm wrong. But aap ki attached sheet m 9,10,11,12 bhee duplicate nahee hain.
column A named as List1 and Column B named as List2.
see if this could help you.
Note: All forumlas are array. So must be confirmed with CSE
regards
Bookmarks