Hi!
I have a simple Table with 4 colums. I want to sort it alphabetically by column A, unless column D equals 0. If D equals 0, I want it to jump to the bottom, but still leave column A to be in alphabetical order (so A,B,C then A,B,C again if that makes sense). I would also like this to happen automatically when new rows are added. Is this possible?
iMac 24″, macOS 14.1
You can build your filter logic into and added column (which can be hidden) and then sort on that column.
Here I used =IF(D2=0,"z"&A2,"a"&A2) in the extra Sort column but other similar formulas would work as well. Use ; instead of , in the formula if your region uses , as the decimal separator.
Unlike a Filters a Sort is not automatic. You either choose 'Sort Ascending' from the contextual menu next to the column letter or click the 'Sort Now' button in the Sort tab in the sidebar.
SG
You can build your filter logic into and added column (which can be hidden) and then sort on that column.
Here I used =IF(D2=0,"z"&A2,"a"&A2) in the extra Sort column but other similar formulas would work as well. Use ; instead of , in the formula if your region uses , as the decimal separator.
Unlike a Filters a Sort is not automatic. You either choose 'Sort Ascending' from the contextual menu next to the column letter or click the 'Sort Now' button in the Sort tab in the sidebar.
SG
Thank you!
Sorting in Numbers - rules
