Hello I have a worksheet containing 2 worksheets.
Worksheet 1 contains 22k records which contain customer numbers in column A and their contact type in column B and Contact date in column C.
Worksheet 2 needs a summary page containing the 18k customer numbers in column A and in Columns B-G woudl be the count of contact type. So for example column B would be email, Column C would be letter etc
My understanding that would be potentially an array with IF statement is that right? any assistance would be great.
By: Mike B