google-sheetsunique

Can I alter a formula using the cell number instead of its cell value?

Here's the formula: =TEXTJOIN(" | ", TRUE, UNIQUE(FILTER(Sheet!E3:E, Sheet!AC3:AC = "joe"))) . The name "joe" is located in the destination sheet in C4. I want to use C4 instead the name "joe" or the cell value. Can somebody help me with us? Tia!

Solution

  • Just put cell reference instead of value. Try-

    =TEXTJOIN(" | ", TRUE, UNIQUE(FILTER(Sheet!E3:E, Sheet!AC3:AC = C4)))