Results 1 to 7 of 7

How - Match/If/Countif

Threaded View

Shermaine2010 How - Match/If/Countif 03-31-2013, 09:53 AM
FDibbins Re: How - Match/If/Countif 03-31-2013, 10:01 AM
Shermaine2010 Re: How - Match/If/Countif 03-31-2013, 11:11 AM
tigertiger Re: How - Match/If/Countif 03-31-2013, 11:57 AM
Shermaine2010 Re: How - Match/If/Countif 03-31-2013, 09:30 PM
Shermaine2010 Re: How - Match/If/Countif 03-31-2013, 11:13 AM
tigertiger Re: How - Match/If/Countif 03-31-2013, 10:04 AM
  1. #1
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    How - Match/If/Countif

    Hi,

    Please refer to file attached.

    Clause one formula - =IF(AND(COUNTIF($A$5:$A$6,A16)=1,INDEX($B$5:$B$6,MATCH(A16,$A$5:$A$6,0))<>B16),"Check ","True")
    Clause two formula - = IF(AND(COUNTIF($A$5:$A$6,A17)<>1,VALUE(MID(B17,4,2))=MONTH($B$1),(VALUE(RIGHT(B17,4))=YEAR($B$1))),"TRUE","Check-Date")

    No idea how to combine it together. Please help.


    Thanks
    Attached Files Attached Files
    Last edited by Shermaine2010; 03-31-2013 at 09:31 PM.

Thread Information

Users Browsing this Thread

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

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