Hello - may I prevail on your collective knowledge please to solve a
problem?

I currently have a pivot table which takes 6 data entry columns, tables the
first entry vertical, the second horizontal, and puts the last 4 in the main
body of the table, counting their incidence in relation to the first 2. A
pretty bog standard pivot table in fact.

My problem is this. In order to use a certain procedure, I have to rewrite
this process to achieve the same end without using a pivot to get there. The
authors of the procedure assure me it can be done using other data filtering
functions within Excel but they don't say how. Anyone got any idea?

Thank in advance

teepee