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...