Hi all,
I am using excel 2013.
Lets see if I can articulate what i'm trying to achieve here....
I have an issue where I am trying to sort rows 'A-AK' from minimum to maximum based on the numerical order of cell 'C' but when I do so all of the formulas that give me the value in cell 'C' get messed around.
Is there a way to construct my formula which is currently
C8 = IF ( H8 > 0 , H8 , E8 )
So that when I sort based on the returned value of C is fixes that original formula to the original row it was intended evaluate where ever it has ended up in the sorted order.
I'm hoping to achieve this without macros as I wouldn't have a clue how to use them.
Thank you in advance.
I am using excel 2013.
Lets see if I can articulate what i'm trying to achieve here....
I have an issue where I am trying to sort rows 'A-AK' from minimum to maximum based on the numerical order of cell 'C' but when I do so all of the formulas that give me the value in cell 'C' get messed around.
Is there a way to construct my formula which is currently
C8 = IF ( H8 > 0 , H8 , E8 )
So that when I sort based on the returned value of C is fixes that original formula to the original row it was intended evaluate where ever it has ended up in the sorted order.
I'm hoping to achieve this without macros as I wouldn't have a clue how to use them.
Thank you in advance.