课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Sort city dates

Sort city dates - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Sort city dates

“

- [Instructor] Somebody thought this was funny. We needed this city data, and they put the established dates into Roman numerals, and we need to sort this data by the established date. Now, what I know is an X is a 10, a V is a five. That's all I really know. So, please, your help is needed to get some numbers that can be sorted, so that then, we can sort this city data. All right? Please do that and convert, sort, come back and I will figure this out. (upbeat music) Welcome back, and hopefully you didn't fall for that curve ball where I was trying to figure out what all of these characters mean, the X, the C, the D, et cetera. Here we go, slide this out of the way, and then I'm going to put established right there. Period, Enter. All right, equals Arabic. Double click, click there, boom, right there, go down, double click. Oh, look at that. Now, we have the years. I'm going to get rid of the underlying…

内容