Urgent!! Advanced formula filling

  • [INDENT]Hi!

    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'!$N25;C$3<='Sheet 2'!$O25;'Sheet 2'!$N27=$C$1);1;0)

    Is it possible to drag down a pattern like this?

    Please help![/INDENT]

  • Re: Urgent!! Advanced formula filling

    Please don't use words like "Urgent" in your thread titles.

    Also, please post links to all your crossposts: Message to Crossposters

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!