Could you create this as two attributes? Then you can import the two fields when you update the price column meaning that they become static rather than dynamic. You can add both of these to be possible to be sorted by.
Then your customisation just becomes hiding one of these based on if the customer is logged in or not.
----
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution" as appropriate. Thanks!