Forum Discussion
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...
I'd add a helper column with formula
=IF(marketcell="China", productcell, teamcell)
and use that as second sort key instead of Team.
I'd add a helper column with formula
=IF(marketcell="China", productcell, teamcell)
and use that as second sort key instead of Team.
HansVogelaar That's actually a great workaround. Thanks!
