Hi, Harlan,

=$A2*$A%2

You have it exactly right. And it's not _terribly_ hard to work out -
the columns must be absolute, because the only source data is in column
A; one of the row terms must be relative, so that it changes normally;
the other must therefore be transpose-relative.


While this syntax is well-defined, I'll bet you most people would
find
it confusing to opaque.

I'm sure they would - most people, after all, find absolute references
confusing. But I think it may be useful enough in enough situations
that a number of people would be happy to have it. With regard to
supporting %A1, A%1, and %A%1 - I agree, for purposes of symmetry and
simple rules. But for the purpose I have in mind - pairwise comparison
among items in a column, all you really need to know is $A%1. It's
hard for me to imagine a need for %A%1, although I guess it could give
you a "transpose-in-place" kind of functionality that might be nice if
you're pasting data into a template.

Thanks for all the feedback.

Peace,
--Carl