Data Validation Offset - Horizontal List

[neodjandre]

Row4 contains a flag 1 or 0.
Row7 contains my dates

I am trying to do a dropdown validation for only the dates which have 1 as the flag in their column.

=OFFSET(LEDGER!$M$7,0,COUNTIF(LEDGER!$M$4:$CV$4,"=1"),0)

My formula evaluates to an error though. is this possible?

thanks in advance
Andrew

 

[RasGhul]

Hi

If your flag is 1 perhaps;


=OFFSET(LEDGER!$M$7,0,COUNTIF(LEDGER!$M$4:$CV$4,1),0)