Forum Discussion
my formula always messsed up while sorting in excel what should i do ??
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.
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.
Riny_van_Eekelen ok! I had some more screenshots. but this time it shows error when I sort. I don't have any idea what I'm doing wrong.
It is my datatis is the formula i had applied in the price columnI sort it A TO Zthe formula has messed up, after I sort it