Forum Discussion
Excel Sorting Issue
Hi
I have a column of numerical data that I want to sort from the Largest to the Smallest, however, I do not have the option of sorting from Largest to Smallest, instead, it only has the optio...
I suspect your numbers are not considered to be numbers but are seen as text.
Assuming these are NOT formulas:
Insert a blank workbook (control+n key), enter a 1 in a cell and hit control+c
Now go to your other workbook, select the "numbers" and hit control+alt+v to open the paste special dialog. Choose "Values" and "Multiply" and press OK.
Assuming these are NOT formulas:
Insert a blank workbook (control+n key), enter a 1 in a cell and hit control+c
Now go to your other workbook, select the "numbers" and hit control+alt+v to open the paste special dialog. Choose "Values" and "Multiply" and press OK.
Hi Jan Karel, thank you for your reply.
However, these are formulas... and the formula is as such: =IF(C4<>"",SUM(E4:M4),"")
- In that case they should add up. Is calc set to automatic?