Forum Discussion

michaelhou's avatar
michaelhou
Copper Contributor
May 26, 2022
Solved

Conditional custom sorting in excel

Hey guys,   I have a simple excel table that I would like to sort based on a few columns. However instead of multi level custom sorting on different columns, I would like the program to execute a d...
excel
  • HansVogelaar's avatar
    HansVogelaar
    May 26, 2022

    michaelhou 

    I'd add a helper column with formula

    =IF(marketcell="China", productcell, teamcell)

    and use that as second sort key instead of Team.

HansVogelaar's avatar
HansVogelaar
MVP
May 26, 2022

michaelhou 

I'd add a helper column with formula

=IF(marketcell="China", productcell, teamcell)

and use that as second sort key instead of Team.

michaelhou's avatar
michaelhou
Copper Contributor
May 26, 2022

HansVogelaar That's actually a great workaround. Thanks!

Resources