+ Reply to Thread
Results 1 to 7 of 7

OR function

Hybrid View

  1. 01-30-2013, 04:34 AM #1
    abubaniyan
    abubaniyan is offline
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Doha, State of Qatar
    MS-Off Ver
    excel 2003, 2007, 2010, 2016
    Posts
    124

    Re: OR function

    why dont you use countifs....!

    regards
    abdul
    Reply With QuoteRegister To Reply
  2. 01-30-2013, 04:40 AM #2
    ryan77705
    ryan77705 is offline
    Registered User
    Join Date
    01-30-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: OR function

    OMG!! Ty so much lol. To think I spent that much time on it and that just took me 5 seconds.
    Reply With QuoteRegister To Reply
  3. 01-30-2013, 05:01 AM #3
    ryan77705
    ryan77705 is offline
    Registered User
    Join Date
    01-30-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: OR function

    Ok for the second part of the question. when I click and drag the formula =IF(countif(a1:a1000,C1),"yes","no") I need c1 to change to c2 like it does but I need a1:a1000 to stay the same. Is there any way to do that?
    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)

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