Mastering the UNIQUE Function in Google Sheets

Поділитися
Вставка
  • Опубліковано 28 лис 2024

КОМЕНТАРІ • 1

  • @worldspirit3534
    @worldspirit3534 18 днів тому

    Hi, would you be kind to help me to resolve my issue. i have table with such values:
    materials, color, input output stock. im using UNIQUE formula to sort that it would not repeat it self.
    Example:
    Category, color, SKU, input , output , stock
    Bead , White , B01 10 , 4 , 6
    Tread , Black, B05 6, 3, 3
    Magnet Red, B07 8, 2, 6
    Green B09 5 1 5
    T-White(Tread) T01
    T-Orange(Tread) T07
    M-Gold(Magnet) M06
    I have issue with category when im using UNIQUE forlmula on first 3 columns thats what im getting its sorting but very wierd. what will be your solution if there is? tnx in advance.