Forum Discussion

kakashi890's avatar
kakashi890
Copper Contributor
Mar 31, 2024

my formula always messsed up while sorting in excel what should i do ??

it is my datait is after when i sort my data has mixed up

excel

9 Replies

Sort By
    • kakashi890's avatar
      kakashi890
      Copper Contributor
      Mar 31, 2024
      right, let me explain, I have 3 column and in price column I have the cost of each product customer bought, the formula in the price column is 300 in first cell, next cell is =300+256 which is 556, next cell is 556+256= 812 so the series is like top cell +256 is the next cell (I hope I am clear :P) The issue is when i try to sort it A To Z the formula got messed up and the numbers gets shuffled and shift from their original place.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Mar 31, 2024

        kakashi890 OK! I'm not surprised that it doesn't work but still don't understand what you have done exactly. Please include some screenshots that show the formulas/numbers that you have in the PRICE column. Or even better, provide a link to your file on OneDrive or similar.

Resources