what formula….

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.

 

thanks

Mike

By: Mike B

Leave a Reply

Your email address will not be published. Required fields are marked *