Totals of variable data (2003)

Topic

New Reply

Hi All,
I have a workbook that I request some help with. (Sample data attached) The workbook has three columns in it.

What I am trying to achieve is a list where each combination of data amongst the three columns is listed and a quantity for the amount of times each combination appears. For example the final list should look a little like:

1BI UNI P

Reply | Quote

Replies

You could sort and count the data by putting it into a pivot table with the data field either as a count of items or the sim of a dummy value set to one for each data point – see attached. If you prefer you can drag the “Type” button to the left column of labels to get the single-column format you specified – this was just more compact. I had to delete some of the data to get the zip file to fit on the Lounge – it was right at 100KB when I tried to post it the first time.

By the way, there were some “P” “F” (etc) values that were distinguishable by leading or trailing spaces. I removed them with a “Trim” function – if this is correct you will have to do the same with your data file…

Reply | Quote

Dean – Thanks so much for your help.

Much appreciated.

Bill

Reply | Quote