Forum Discussion
Data Validation for previous rows
Re. We're currenthly validating LEN>0 if that helps
If the SUMPRODUCT formula previously shared does what you want with regard to columns C,F,H no update is requiredCan that code also include a check that columns B-H cannot be populated unless A is also populated?
A different Data Validation rule must apply to columns B-H then:
With the above example
- Select B2:H16
- Data Validation rule Custom: =$A2 <> "" AND uncheck option Ignore blank:
Sample updated and attached
Hi a_bonsey
Not sure this is exactly what you want as we have no idea how you currently validate entries in column A...
Data Validation applied to A2:A16:
=SUMPRODUCT(--(ROW(A$1:A1)<ROW()),--(A$1:A1<>""), --(C$1:C1<>""), --(F$1:F1<>""), --(H$1:H1<>"")) = COUNTA(A$1:A1)
In the above example nothing can be enterred in A10, A11,...A16 as row 9 is incomplete (H9 not filled). Corresponding sample attached
- Thanks for that. I'll take a look.
We're currenthly validating LEN>0 if that helpsSorry, all a bit new to this.
Can that code also include a check that columns B-H cannot be populated unless A is also populated?
Re. We're currenthly validating LEN>0 if that helps
If the SUMPRODUCT formula previously shared does what you want with regard to columns C,F,H no update is requiredCan that code also include a check that columns B-H cannot be populated unless A is also populated?
A different Data Validation rule must apply to columns B-H then:
With the above example
- Select B2:H16
- Data Validation rule Custom: =$A2 <> "" AND uncheck option Ignore blank:
Sample updated and attached
