Offset Function With Validation

    Team,


    Please find attached the excel sheet.


    In sheet1 I have named the range I have inserted a Name(Test) for range $A$1:$A$2(range contains only texts) and have a list validation on cell $B$1 using the name. This works perfectly.


    In sheet2 I have named the range I have inserted a Name(Test1) for range $A$1:$A$2(range contains only numerics) and have a list validation on cell $B$1 using the name. This doesn't work.


    Kindly provide help on the same.


    Regards,
    Malay

    Re: Offset Function With Validation


    Your Offset is slightly off... see if this helps...


    =OFFSET(Sheet2!$A$1,0,0,COUNTIF(Sheet2!$A$1:$A$8,">0"),1)



    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

    Re: Offset Function With Validation


    try a dynamic named range like this:


    =OFFSET(Sheet2!$A$1,0,0,COUNT(Sheet2!$A$1:$A$100), 1)

Participate now!

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

Register Yourself Login