+ Reply to Thread
Results 1 to 5 of 5

Find unique value comparing multiple sheets

  1. #1
    Registered User
    Join Date
    06-06-2014
    Location
    Nepal
    MS-Off Ver
    MS office professional 2016
    Posts
    71

    Find unique value comparing multiple sheets

    Here in attached sheets i want to find unique value comparing a master sheets with there multiple slave sheets .Requesting to help on it .
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,972

    Re: Find unique value comparing multiple sheets

    FAR too little information.

    If a value occurs in the slave sheets, does it only occur once, or can it occur multiple times?

    If multiple times, can it appear more than once on a single sheet?

    What cell range is to be checked on the slave sheets?

    How many slave sheets are there?
    Glenn



  3. #3
    Registered User
    Join Date
    06-06-2014
    Location
    Nepal
    MS-Off Ver
    MS office professional 2016
    Posts
    71

    Re: Find unique value comparing multiple sheets

    If a value occurs in the slave sheets, does it only occur once, or can it occur multiple times?>>>>>> yes it occur multiple times.

    If multiple times, can it appear more than once on a single sheet?>>>>>>yes it appear more then once on a single sheets

    What cell range is to be checked on the slave sheets? >>>>>>>>>any whole column at slave sheets.

    How many slave sheets are there?>>>I have at 10 slave sheet.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,972

    Re: Find unique value comparing multiple sheets

    Any formula checking 10 different sheets, in their entirety, will be VERY VERY slow. You will really need VBA. Is that acceptable for you? If so, I will move your thread.

  5. #5
    Registered User
    Join Date
    06-06-2014
    Location
    Nepal
    MS-Off Ver
    MS office professional 2016
    Posts
    71

    Re: Find unique value comparing multiple sheets

    sorry for my late reply .kindly request you to proceed with VBA .thankyou

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Comparing 2 non-sequence Sheets in excel to find unique results
    By mimranflmsa in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-02-2021, 11:18 AM
  2. Replies: 5
    Last Post: 07-10-2018, 08:02 AM
  3. Comparing Two Sheets with Unique Relationship
    By bobredford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2017, 06:43 PM
  4. [SOLVED] Find Common Values across multiple sheets based on Unique ID
    By desibabuji in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-12-2014, 05:38 PM
  5. How to find unique records from multiple sheets
    By Mike Nelson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 08:38 AM
  6. [SOLVED] Comparing 2 Worksheets to find Unique additions
    By ExcelNewbie2011 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2011, 04:20 AM
  7. Replies: 4
    Last Post: 02-14-2008, 12:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1