Arranging/filtering 3 columns of data in excel

خرید بک لینک

I have an excel file (see the picture) for which I want to specifically arrange my data.

What I want is "col1" to be arranged from the most past date, so 5/1/2016 then 5/2/2016 and so on. With that, I want "col2" to have everything in alphabetical ascending order, and the dates in "col3" to be just like in "col1". The key column is "col1" meaning everything needs to based on that.

I did it manually, but I can't do that with 1000 lines in excel.

Excel file picture

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 230 تاريخ: جمعه 17 ارديبهشت 1395 ساعت: 23:21

صفحه بندی