This is probably a stupid question, but by "same size" do you mean
defined range or number of filled cells?

TDate range is: 'trainer data'!$E:$E
TQ7 range is: 'trainer data'!$U:$U

There will be some rows with blank cells in TQ7 but data in TDate. Does
that make sense?

Thanks! Trish