Forum Discussion

varbergt's avatar
varbergt
Copper Contributor
Dec 22, 2023

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.

 

AlbertsonsEastCoffee
Food 4 LessWestTea
Food 4 LessEastTea
CostcoWestCoffee
CostcoWestTea

 

Result using =UNIQUE(INDEX(tblUnique;SEQUENCE(ROWS(tblUnique));{1\3}))

tblUnique is the above table.

AlbertsonsCoffee
Food 4 LessTea
CostcoCoffee
CostcoTea

 

Any idea how this can be done?

Formulas and Functions

3 Replies

Sort By
  • Salposi's avatar
    Salposi
    Copper Contributor
    Dec 22, 2023

    any idea ...

    or

    =UNIQUE(HSTACK(TAKE(tblUnique,,1),TAKE(tblUnique,,-1)))

    or

    =UNIQUE(HSTACK(DROP(tblUnique,,-2),DROP(tblUnique,,2)))

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Dec 22, 2023

      Salposi 

      Rather odd that you edited your answer to include the formula I had already posted more than an hour earlier ????

Resources