您要查找的是不是:
- Make sure that the criteria range does not overlap the list. 确保条件区域没有与列表相重叠。
- Although the criteria range can be located anywhere on the worksheet, do not place the criteria range below the list. 虽然条件区域可以在工作表的任意位置,但不要将条件区域置于列表的下方。
- To find rows that meet multiple criteria for one column, type the criteria directly below each other in separate rows of the criteria range. 要查找满足“一列中有多个条件”的行,请直接在条件区域的各行中依次键入条件。
- To find rows that meet multiple criteria in multiple columns, type all of the criteria in the same row of the criteria range. 要查找满足“多列中有多个条件”的行,请在条件区域的同一行中键入所有条件。
- To perform an operation on an entire column in a database, enter a blank line below the column labels in the criteria range. 若要对数据库的整个列进行操作,请在条件区域的相应列标签下方保留一个空行。
- To find rows that meet multiple criteria in multiple columns, where any criteria can be true, type the criteria in different rows of the criteria range. 要查找满足“多列中有多个条件,其中所有条件都必须为真”的行,请在条件区域的不同行中键入条件。
- In the data range (A6: D10), the criteria range (D1: D2) displays rows that contain "Produce" in the Type column by using the EXACT function to perform a case-sensitive search (A10: C10). 在数据区域(A6:D10)中,条件区域(D1:D2)通过使用EXACT函数执行区分大小写的搜索显示“类型”列中包含“农产品”的行(A10:C10)。
- Points are given for meeting a series of detailed service-related criteria ranging from friendliness and attentiveness of staff to cleanliness and services available. 分数的评定是由一连串详细的、相关联服务的标准。
- It has come within the range of practical politics. 这就属于可实施性政治的范围了。
- We sell a wide range of ales and stouts. 我们出售种类繁多的浓啤酒和黑啤酒。
- Come and see our range of gardening tools. 来瞧瞧我们的成套园艺工具吧。
- My own criterion of success is the ability to work joyfully. 我自己成功的标准是能够快乐地工作。
- It came within my range of vision. 该物体进入了我的视野。
- Love is sometimes put in range with a career. 人们往往认为爱情和事业是并驾齐驱的。
- A range of hills rose on their left. 连绵的小山耸立在他们的左侧。
- A standard of measurement or judgment; a criterion. 标准测量或判断的标谁; 标准
- She is still within range of my gun. 她仍在我枪炮的射程之内。
- Shout as soon as he comes within range. 他一到听得见的距离你就叫。
- Shout as soon as she comes within range. 等她一走到听得见的地方就呼喊。
- The ship came within range of vision. 已经看得见那条船了。