Why can't you just use sumproduct...
=sumproduct(--(a1:a10=d1:d10))
Wazooli
"Molochi" wrote:
Hi
I'm setting up a spreadsheet and will have two columns of text... so for
instance columns A1:A5 could contain
Andy
Bob
Chris
Dave
Eddie
while columns D1:D5 could contain
Andy
Bill
Colin
Dave
Eric
What I want to do is find a way of doing a count of the number of
occurrences a name appears across BOTH columns. I can do it down a single
column with a Pivotable, but is there an easy way to do it down multiple
columns?
|