Dynamic Range (Conditional)

[zinah]

Hi,

I have this dynamic range which depends on dynamic data and below condition:

If the value in cell AC10 is not equal to any of the values in Range: AK3:AK9 then change the formula should be:

=ADDRESS(ROW(AE14),COLUMN(AD14),4)&":"&ADDRESS(IFERROR(MATCH(0,AG15:AG44,0)+ROW(AG14)-1,ROW(AD44)),COLUMN(AF14),4)

But if the value in cell AC10 is equal to any of the values in Range: AK3:AK9 then change the formula should be:

=ADDRESS(ROW(AE14),COLUMN(AD14),4)&":"&ADDRESS(IFERROR(MATCH(0,AG19:AG44,0)+ROW(AG14)-1,ROW(AD44)),COLUMN(AF14),4)

Can anyone help me figuring this out?


Thanks

 

[zinah]

THANK YOU!!! It worked perfectly great, I really appreciate your time and valuable support!

 

[pgc01]

You're welcome. Thanks for the feedback.