D
DTTODGG
Hello Excel Gurus-
I have a giant spreadsheet with a whole bunch of data accounting needs, but
I don't want. This spreadsheet is shared and updated daily, so I can't just
copy it somewhere and do my work on the copied version.
Rows 1-6 have no significant data - kinda header info.
Row 7 is the "label" Row
Columns A - AA (although some of these columns do not yet contain any data)
Rows 8-1200 Contain information I do not care about
Rows 1201 - 1400 and onward is where my data is located
One columns is a list of customers.
I would like to know how many customers I have (minus duplicates)
Which customers have the most duplicates
So, I attempted a pivot table to break this down and get the PivotTable
field is not valid error.
Is there a way to specify what Row has the labels and then which rows I'm
looking at?
If not, is there a way using a formula rather than the pivot table?
I hope you can understand this and thanks in advance-
I have a giant spreadsheet with a whole bunch of data accounting needs, but
I don't want. This spreadsheet is shared and updated daily, so I can't just
copy it somewhere and do my work on the copied version.
Rows 1-6 have no significant data - kinda header info.
Row 7 is the "label" Row
Columns A - AA (although some of these columns do not yet contain any data)
Rows 8-1200 Contain information I do not care about
Rows 1201 - 1400 and onward is where my data is located
One columns is a list of customers.
I would like to know how many customers I have (minus duplicates)
Which customers have the most duplicates
So, I attempted a pivot table to break this down and get the PivotTable
field is not valid error.
Is there a way to specify what Row has the labels and then which rows I'm
looking at?
If not, is there a way using a formula rather than the pivot table?
I hope you can understand this and thanks in advance-