Forum Discussion

Rohan110's avatar
Rohan110
Copper Contributor
Jun 01, 2023

Sorting Excel Table doesnt sort the non-table data; Query autofills manually edited cells with formu

Hi,   I'm using Query to automatically update my data from A to D (Consider D header to be Category)columns. I have a column on E whose formula is basically =Table_Categorizer[@Category]   Proble...
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 01, 2023

Hi Rohan110 

 

Assuming I understood you're in front of a well known problem/limitation that has no reliable solution if your Source table doesn't have Unique IDs - see if Matt's approach can help you...

  • Rohan110's avatar
    Rohan110
    Copper Contributor
    Jun 10, 2023

    Lorenzo 

     

    Hi tried the above method but it still doesnt work.

    The first cell in the Manually changed category has the formula =[@Category]. So every time i refresh, the eating out value changes to the above formula.

     

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jun 10, 2023

      Hi Rohan110 

      As I understand you want to make exception(s) to the "rule" (=[@Category]). AFAIK this isn't reliably possible. Unchecking "Preserve column sort/filter/layout" (in Data > Properties) has some effects...