+ Reply to Thread
Results 1 to 9 of 9

Very Very Urgent Help needed For And Function or Match Function to compare the output

Hybrid View

  1. 06-01-2016, 10:19 PM #1
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Very Very Urgent Help needed For And Function or Match Function to compare the output

    Hi All , Good Morning

    I Need a Small help , I have a File where i have to compare users with different reports (Ideally all report should have same user) however that is not the case so i am checking every user in 4 diff report , where i have to check user in 1,2,3,4 report separately and also check if a user is present in 1,3 report and not in 2,4 , or may be 3,4 and not in 1,2 and vice versa
    kindly help with the formula and suggest the formula which i have put is correct or may be any other can be used
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-02-2016, 12:40 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    OK instead of your ISNA(MATCH()) formula for the 1-to-1 matches, try this...
    =COUNTIF($B$2:$B$18,A2)<1

    But Im not sure what you expect in columns I etc? Who is AVL?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-02-2016, 12:54 AM #3
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    Thanks a lot for Reply Avl is Available ,
    so i meant users in A available in B Row but not in C row
    Reply With QuoteRegister To Reply
  4. 06-02-2016, 01:46 AM #4
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    So can you help me with the Formula in I Row on wards ???
    Reply With QuoteRegister To Reply
  5. 06-02-2016, 02:41 AM #5
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    As of now its a very long process i have to use i have to compare A row to B and out of the result (Available users ) i have to compare it to C ,
    Reply With QuoteRegister To Reply
  6. 06-02-2016, 02:46 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,197

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    @Ford - I think AVL means "available".
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 06-02-2016, 02:49 AM #7
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    Quote Originally Posted by AliGW View Post
    @Ford - I think AVL means "available".
    hahahahaha,Very funny , but my question is still open Ali !

    I understand you have typed "Not" By mistake
    Last edited by a1ksingh; 06-02-2016 at 02:53 AM.
    Reply With QuoteRegister To Reply
  8. 06-02-2016, 02:56 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,197

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    Quote Originally Posted by a1ksingh View Post
    hahahahaha,Very funny , but my question is still open Ali !

    I understand you have typed "Not" By mistake
    Yes, I corrected my post just after I typed it.

    Why do you say "but my question is still open Ali"? Who said it was closed? Not me! If you don't need my help, though, that's fine.
    Reply With QuoteRegister To Reply
  9. 06-02-2016, 03:00 AM #9
    a1ksingh
    a1ksingh is offline
    Registered User
    Join Date
    07-09-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Very Very Urgent Help needed For And Function or Match Function to compare the output

    I though you know Ford and pulling his leg , and i am expecting resolution

    That will be really helpful if you can help bud .
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. URGENT HELP! Match function with multiple criteria
    By nickynec in forum Excel General
    Replies: 10
    Last Post: 09-02-2015, 03:36 PM
  2. Nested IF function (urgent help needed)
    By HJalal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 11:59 AM
  3. Compare 2 columns to a 3rd column function needed
    By Jason_McCoy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2012, 12:29 AM
  4. Automated function - urgent help needed
    By monykaram in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2011, 07:22 PM
  5. Using Match function output as a variable
    By iii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2009, 06:01 PM
  6. function needed to compare lists
    By TCape in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2008, 08:20 AM
  7. Urgent Help Needed with coloumn compare
    By Brento in forum Excel General
    Replies: 1
    Last Post: 07-28-2005, 08:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1