วันอังคารที่ 20 ธันวาคม พ.ศ. 2554

Excel: how to sort the column of numbers?

Order a numeric column in Excel.

Excel: how to sort the column of numbers?

Question :

I have Excel 2002, I wanted to put in a column the different mobile phone numbers. But in the end to ensure that the numbers are put in order (just to see those twin) command or formula should I give?

Thank you.

Answer :

Simple, select with the mouse all the boxes where you entered the mobile phone numbers in the menu then go Data-> Sort ... and if you choose ascending or descending order: If there are duplicates will be contiguous.

See Pictures and Read more : Excel: how to sort the column of numbers?

ไม่มีความคิดเห็น:

แสดงความคิดเห็น