Page 1 of 2 12 LastLast
Results 1 to 12 of 14

Thread: Comparing two different sheets in Excel

  1. #1
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default Comparing two different sheets in Excel

    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 ....

  2. #2
    mohammadhanif14's Avatar
    mohammadhanif14 is offline Advance Member
    Last Online
    9th October 2023 @ 04:12 PM
    Join Date
    29 Nov 2010
    Location
    where i am
    Gender
    Male
    Posts
    1,701
    Threads
    200
    Credits
    394
    Thanked
    220

    Default

    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.

  3. #3
    mohammadhanif14's Avatar
    mohammadhanif14 is offline Advance Member
    Last Online
    9th October 2023 @ 04:12 PM
    Join Date
    29 Nov 2010
    Location
    where i am
    Gender
    Male
    Posts
    1,701
    Threads
    200
    Credits
    394
    Thanked
    220

    Default

    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.

  4. #4
    mohammadhanif14's Avatar
    mohammadhanif14 is offline Advance Member
    Last Online
    9th October 2023 @ 04:12 PM
    Join Date
    29 Nov 2010
    Location
    where i am
    Gender
    Male
    Posts
    1,701
    Threads
    200
    Credits
    394
    Thanked
    220

    Default

    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.

  5. #5
    mohammadhanif14's Avatar
    mohammadhanif14 is offline Advance Member
    Last Online
    9th October 2023 @ 04:12 PM
    Join Date
    29 Nov 2010
    Location
    where i am
    Gender
    Male
    Posts
    1,701
    Threads
    200
    Credits
    394
    Thanked
    220

    Default

    aap ka masla hal howa kia?

  6. #6
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    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

  7. #7
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    Friends come up with the solution,its the most common problem.....i m waiting....

  8. #8
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post

    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

  9. #9
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    ‏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
    Attached Files Attached Files

  10. #10
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post

    see the attached file.
    Attached Files Attached Files

  11. #11
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    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...
    Attached Files Attached Files

  12. #12
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Post

    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
    Attached Files Attached Files

Page 1 of 2 12 LastLast

Similar Threads

  1. Inserting Page numbers in Excel Sheets.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 7
    Last Post: 4th April 2016, 02:57 PM
  2. i want to need excel practice sheets
    By waqasswedens in forum Ask an Expert
    Replies: 1
    Last Post: 11th June 2013, 09:19 PM
  3. Ms excel 2007 mein kitni sheets add kar sakty hain
    By feeze in forum Ask an Expert
    Replies: 2
    Last Post: 21st November 2011, 07:21 AM
  4. Bed Sheets WOW
    By meerirfan in forum Photo Gallery
    Replies: 9
    Last Post: 8th September 2011, 06:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •