Fictional assignment
Prepare a clean staffing list for Solace Field Services.
Mina in operations received names with extra spaces, numeric hours stored as text, and repeated employee IDs. Keep the raw export, create clean columns and report distinct employee count and hours for the East team.
All records and amounts are fictional practice data. Deliver the completed workbook and a formula-based answer that updates when the inputs change.
An imported value can look usable while still being text. That distinction affects totals, comparisons and dates. Keep the raw export so you can inspect each transformation rather than overwriting evidence of a bad import.
This workbook separates names, hours and dates into clean columns. TRIM removes extra ordinary spaces; PROPER changes letter case, but you should still review surnames whose preferred spelling differs. VALUE converts numeric text. DATEVALUE converts date text using the workbook's US English settings. Repeated IDs represent repeated export records here, so distinct employee count uses UNIQUE. Sum hours only over the requested team, and remember that a repeated record can still distort a workload total.