I’m working on a spreadsheet for my business.
There is a field, calculated from other fields, which I want to sort the spreadsheet by.
When I sort the data, I get the data ordered thusly:
For the record, here’s the formula used to generate this field:
=IF(AF2<599,0,((AI2L2AH2*AG2)-AA2))
For confidentiality reasons, I can’t disclose what I’m actually counting, forecasting, etc here.
Well, found a temporary work-around.
Selected the entire column.
Then copied.
Selected an unused column.
Then pasted, selecting the option to paste the values (the type of paste where it shows (1,2,3) in Excel.)
Then sorted based on the new column.
That sort worked logically, and perfectly.
Still like feedback, though.
When you sort based on that column of numbers (139.00, 108.50, etc.) are you including in the sort range the other columns that have values for the formula? I suspect you’re not. If you are trying to sort just that one column it won’t work since the formula will just recalculate the values again. And of course if you copy the values of that column of number somewhere else and sort it, it will work since you’re sorting values and not the formulas. That’s all I can think of without seeing your worksheet.
I made up a bunch of numbers and used your formula and my spreadsheet is sorting fine.
Did you try copying the entire contents of the sheet and pasting them into a New worksheet?
I’ve had a particular spreadsheet get wanky on me and not even do multiplication correctly in some cells, but if I just put the exact copy into a new worksheet it goes fine.
If you still can’t figure it out, post the worksheet somewhere and we can look at it. It’s pretty tough to figure out what’s wrong from just your description.