Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to fill in the sequence after excel filtering
How to fill in the sequence after excel filtering
Materials/tools: Excel20 10

1. The monthly sales volume of sunflower is posted in the corresponding target area.

Step 2 screen sunflowers by name

3. If you copy and paste directly after screening, the following tragedy will occur.

4. Enter the formula = index ($ E $8: $ G $ 13, COUNTIF (B $ 1: B2, B2), 3) in the C2 cell, and then drag the mouse down to complete the filling.

5. The sunflower sales corresponding to the name selection view effect have been filled in in order.