Forum Discussion
Unique for multiple columns without using Name Manager
I have below table and would like to use the unique formula without using the Name Manager to get unique values based on column 1 and 3. Albertsons East Coffee Food 4 Less West Tea F...
any idea ...
or
=UNIQUE(HSTACK(TAKE(tblUnique,,1),TAKE(tblUnique,,-1)))
or
=UNIQUE(HSTACK(DROP(tblUnique,,-2),DROP(tblUnique,,2)))
Rather odd that you edited your answer to include the formula I had already posted more than an hour earlier ????