Hi There,
I am hoping someone can help me. I've been given an assignment to create an excel document based of the following:
66 reports. 1 report=1 isusue=1 customer
So basically 1 customer could have all 66 reports, if they have 66 issues. There are 30,000 customers. Which could mean 66 x 30,000 total reports.
On the excel spread sheet the columns will represent the 66 reports (issues) and the rows will represent each customer's number. The individual cells must be check off for each issue each customer has, which could be a total of 66 issues per customer.
Should I try making a pivot table or is there another better way of doing this?
Any help is GREATLY appreciated!
I am hoping someone can help me. I've been given an assignment to create an excel document based of the following:
66 reports. 1 report=1 isusue=1 customer
So basically 1 customer could have all 66 reports, if they have 66 issues. There are 30,000 customers. Which could mean 66 x 30,000 total reports.
On the excel spread sheet the columns will represent the 66 reports (issues) and the rows will represent each customer's number. The individual cells must be check off for each issue each customer has, which could be a total of 66 issues per customer.
Should I try making a pivot table or is there another better way of doing this?
Any help is GREATLY appreciated!
