Hiya Frank
The concept is good, very good in fact - the only problem is that the two
columns might run to hundreds of entries so I could do with some automatic
way of identifying the contents and then counting them.
I guess I could copy and past the two columns into a hidden third column and
Pivotable it, but I'm sure there must be an easier way?
"Frank Kabel" wrote:
Hi
try
=COUNTIF(A1:A5,"Andy")+COUNTIF(D1:D5,"Andy")
--
Regards
Frank Kabel
Frankfurt, Germany
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?
|