Current location - Education and Training Encyclopedia - Education and training - How does excel seek to screen out the records with the title of lecturer and total income higher than 2,345 yuan and lower than 2,400 yuan?
How does excel seek to screen out the records with the title of lecturer and total income higher than 2,345 yuan and lower than 2,400 yuan?
Point data filtering-automatic filtering. At this point, there is a drop-down arrow in the lower right corner of the lecturer and total income. Click the drop-down arrow for Total Revenue and select Custom. In the first box, select greater than, enter 2345 in the box on the right, then select less than in the first box below and enter 2400 in the box on the right. Ok, copy and paste the results to another location. If you want to restore the original table style, click the drop-down arrow of Total Revenue or Instructor.