Easy: Filter left on
AutoFilter is still filtering Status=Open. Row numbers jump; Closed orders look “deleted”. Clear the filter — all 8 rows return.
AutoFilter Status=Open वर आहे. Closed rows दिसत नाहीत — delete वाटते. Filter clear करा.
AutoFilter Status=Open पर है। Closed rows गायब — delete लगता है। Filter clear करें।
Why → What → How
Why: Shared files often ship with a filter still on. Juniors panic about missing data.
What: Eight orders; broken file filters to Open. Look at row-number gaps. Clear filter to see all.
How:
- Open Orders.
- Look at row headers — gaps mean filter.
- Data → Filter / clear funnel on Status.
- Confirm COUNTA = 8.
Ravindra Bagale’s Tip
Before you say “rows were deleted”, check the filter funnels and row-number sequence.
Ravindra Bagale’s Tip – मराठी
“Rows delete झाल्या” म्हणण्यापूर्वी filter funnel आणि row numbers तपासा.
Ravindra Bagale’s Tip – हिंदी
“Rows delete हो गईं” कहने से पहले filter funnel और row numbers देखो।
Bugs explained (with mini examples)
Bug 1 — Filter still on
Bug 2 — Panic delete narrative
Practice tasks (12)
- Task 1. Spot the funnel icon on Status.Hint: Filter on.
- Task 2. Count visible vs expected rows.Hint: Gaps in row numbers.
- Task 3. Clear the filter.Hint: All 8 show.
- Task 4. COUNTA on OrderID.Hint: 8.
- Task 5. Explain to a junior in one sentence.Hint: Filter was on.
- Task 6. Turn filter on City=Surat — how many?Hint: Count.
- Task 7. Clear again.Hint: All back.
- Task 8. Does deleting a filtered row delete hidden ones too?Hint: Dangerous — avoid.
- Task 9. Interview tip.Hint: Always clear filters before auditing.
- Task 10. Find Open amount sum after clear.Hint: Use SUMIF.
- Task 11. Bonus: convert to Table.Hint: Ctrl+T.
- Task 12. Save a clean copy.Hint: No filter.
In-browser formula check
Type the fixed formula you would put in the named cell. We check formula text — open the workbook for full recalculation.
Step-by-step solution (try first)
- Clear AutoFilter.
- All 8 orders visible. COUNTA=8.
Quick quiz