Easy: Duplicate header breaks sort
Absolute refsNumbers as textLeading spacesFilter left onChart range% vs decimalDuplicate headerROUND vs displayFreeze panesPaste valuesVLOOKUP & textVLOOKUP col indexHLOOKUP TRUESUMIF spacesCOUNTIFS ORIF nest orderDate serialINDEX MATCHWildcard COUNTIFMixed currencyCircular & datesCircular interest3D sum renameNamed range staleCF vs IFPivot staleHard-coded NPVValidation movedPQ step orderTyped-over formulaSUM wrong anchorsFiscal year Apr–MarFind all bugsInterview oral
A second “Name/Dept/Score” header was pasted mid-list. Sort by Score puts the word Name among people. Delete the duplicate header row.
मधोमध दुसरी header row आहे. Sort करताना "Name" लोकांत येते. Duplicate काढा.
बीच में दूसरी header row है। Sort पर "Name" लोगों में आती है। Duplicate हटाएँ।
About this data: Made-up roster for Rohan Kapoor (Jaipur hotel) and Marie Dubois (Paris). Practice only.
Why → What → How
Why: Copy-paste while building lists often re-pastes headers.
What: Staff scores; broken file has duplicate header. Remove it, then sort safely.
How:
- Open Staff.
- Find the extra header mid-table.
- Delete that row.
- Sort by Score descending.
Ravindra Bagale’s Tip
Before Sort, confirm exactly one header row and no blank separator rows inside the block.
Ravindra Bagale’s Tip – मराठी
Sort पूर्वी एकच header आणि आत रिकाम्या rows नाहीत हे पहा.
Ravindra Bagale’s Tip – हिंदी
Sort से पहले सिर्फ एक header और बीच में खाली rows न हों।
Bugs explained (with mini examples)
Bug 1 — Duplicate header
Text "Name" sorts with names.
Bug 2 — False “data” row
Scores become unsortable cleanly.
Practice tasks (12)
- Task 1. Locate duplicate header.Hint: Mid list.
- Task 2. Delete it.Hint: One header left.
- Task 3. Sort Score Z→A.Hint: Marie top.
- Task 4. Does header stay put with My data has headers?Hint: Yes.
- Task 5. Interview sentence.Hint: “Duplicate header broke sort.”
- Task 6. Add a person — keep one header.Hint: Careful paste.
- Task 7. Why blank rows inside lists hurt sort.Hint: Split ranges.
- Task 8. Convert to Table.Hint: Helps.
- Task 9. Filter Dept=Front after fix.Hint: Works.
- Task 10. Undo sort and re-do.Hint: Practice.
- Task 11. Bonus: freeze header.Hint: A2 or proper row.
- Task 12. Save clean file.Hint: Done.
Step-by-step solution (try first)
- Delete duplicate header row.
- Sort with “My data has headers” checked.
Quick quiz
Q1. A header mid-table when sorting:
Q2. Best fix:
Q3. “My data has headers” needs:
Q4. This bug often comes from:
Q5. After fix you should: