Dynamic Cross Tab Report - Unique items w/ criteria

[Nobes]

Hello,

I saw this video on Excel is Fun’s you tube and was wondering if any one knows a method to calculate unique items with two criteria and have the formula spill into a two dimensional array with totals for rows and columns, similar to the COUNTIFS formula used in the video.

The formula must be able to handle at least two criteria (sales person, date of order) the unique it is a product reference number.

Columns in the data are as follows:

Column A - product ref
Column B - Sales person
Column C - Date of Order

Dynamic cross tab report with totals

 

[OaklandJim]

The need is obvious to you but not to me. Ideally you post a worksheet with fake-but-realistic data so a helper does not have to try to recreate it to work with. Do that using the link icon above the message area. Put the file on Dropbox, 1Drive or Google Drive.

 

[Nobes]

The need is obvious to you but not to me. Ideally you post a worksheet with fake-but-realistic data so a helper does not have to try to recreate it to work with. Do that using the link icon above the message area. Put the file on Dropbox, 1Drive or Google Drive.

Hello,

I have posted a Onedrive link below to the excel file.

Excel is fun unique count spilled array

Kind Regards,

Nobes