As-is, no. You need to check/touch up the source data (in x) for completeness
(eg via autofilter).
--
Max
Singapore
---
"Curtis" wrote:
Thanks...This works however my source data cols F, G, H (in x) containing
the day, month, year numbers may not always have data in th respective range for all divisions. Anyway around this