方法A：一个升序列，一个降序列

Method A: One ascending column, one descending column

youdao

可以复制并粘贴升序列中的表达式，然后只需把条件中的值由正数改为负数。

You can copy and paste the expression from the ASC column, and only have to replace the values in the conditions from positive to negative.

youdao

要搜索的序列(包含按ascii升序排序的数据)。

The series that will be searched (containing data sorted in ASCII ascending order).

youdao

要搜索的序列(包含按ascii升序排序的数据)。

The series that will be searched (containing data sorted in ASCII ascending order).

youdao