On Tue, 11 Mar 2008 01:12:33 -0700 (PDT), Lan Mind wrote:

If I wanted to do 3 separate rows like columns like A, J and D what is
the syntax? Would I put commas between like so?:

=transpose(uniquecount(A1:A9512,D1:D9512,J1:J9512 ))


You're very close. You need to also enclose the entire range within a pair of
parentheses:

=transpose(uniquecount((A1:A9512,D1:D9512,J1:J9512 )))

or you should be able to NAME the range, and refer to it by the Name.
--ron