Results 1 to 2 of 2

Thread: Urgent!! Advanced formula filling

  1. #1

    Exclamation Urgent!! Advanced formula filling

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I need to get this done for work and i can't seem to find how to do it.

    In sheet 1:

    c8: =IF(AND(C$3>='Sheet 2'!$N5;C$3<='Sheet 2'!$O5;'Sheet 2'!$N7=$C$1);1;0)
    c9: =IF(AND(C$3>='Sheet 2'!$N10;C$3<='Sheet 2'!$O10;'Sheet 2'!$N12=$C$1);1;0)
    c10: =IF(AND(C$3>='Sheet 2'!$N15;C$3<='Sheet 2'!$O15;'Sheet 2'!$N17=$C$1);1;0)

    I want to be able to drag down this formula to c200 following this pattern creating

    c11: =IF(AND(C$3>='Sheet 2'!$N20;C$3<='Sheet 2'!$O20;'Sheet 2'!$N22=$C$1);1;0)
    c12: =IF(AND(C$3>='Sheet 2'!$N20;C$3<='Sheet 2'!$O20;'Sheet 2'!$N27=$C$1);1;0)

    Is it possible to drag down a pattern like this?

    Please help!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Please don't use words like Urgent in your titles, and also please post links to other forums that you have posted in.

    Message to Crossposters

Posting Permissions

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