You say your data starts in Row 1. Does that mean that you have no
headers and that you won't be filtering your data?

In article ,
"Sam via OfficeKB.com" wrote:

Hi Domenic,

Thanks a lot for the alternative solutions - showing various ways to arrive
at the same end result. Very much appreciated.

With regard to headers: the data I'm using was extracted from another
worksheet and now starts in "Row number one" of each respective column, does
this mean the other two solutions are not viable if my data is in "Row number
one" of the worksheet?

Cheers
Sam