
Concluído
Publicado
Pago na entrega
My Excel 365 workbook contains a column of true date values—no text strings or custom codes—yet the filter drop-down refuses to group them by Year > Month > Day. Instead, it lists every single date one by one, making quick summaries impossible. I need a quick, clean fix that restores the normal year-based hierarchy in the filter and confirms that any new dates I add will behave the same way. Please return the corrected file and a brief note outlining what was wrong and how you resolved it so I can avoid the issue in future workbooks.
ID do Projeto: 40173148
9 propostas
Projeto remoto
Ativo há 1 mês
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
9 freelancers estão ofertando em média $14 USD for esse trabalho

As a Certified AI Developer and Data Science Professional, I possess the necessary Excel skills to quickly resolve your issue. Excel is one of my core competencies, and I have leveraged this knowledge in numerous projects for data analysis, automation, scraping and extraction from websites - all tasks that require deep proficiency in Excel. My expertise extends beyond mere technical competence. My training in AI Development has equipped me with creative problem-solving skills which will be invaluable for diagnosing the root cause of your filter issue and providing a comprehensive solution while avoiding future repeats. My Python Automation certification reaffirms my ability to write clean, efficient code; ensuring that not only will we restore your normal year-based hierarchy but any new dates you add will be treated correctly too. In addition, my overall skill-set does not just limit to data analysis but also encompasses skills like building chatbots and creating web apps with Flask - indicating my ability to handle a variety of tasks efficiently. I believe that leveraging AI + Automation is key to unlocking insights from data and optimizing workflows. With me on your team, you gain an invaluable asset for your business. Let's get that time-saving repair done swiftly and professionally!
$11 USD em 7 dias
0,8
0,8

Hi Ginger L., I'm Matthew C., a seasoned freelancer with expertise in Excel and data management. I understand you're facing an issue with the date filter in your Excel workbook not grouping by Year > Month > Day. I'll solve this by ensuring your dates are formatted correctly and the filter settings are adjusted to restore the normal hierarchy. Recently, I helped another client with a similar Excel filtering issue, which was resolved quickly and efficiently. Could you confirm if there are any specific updates or additional data you plan to add soon? Let's get your workbook functioning smoothly again.
$20 USD em 2 dias
0,0
0,0

Hi There, I understand you're facing challenges with Excel 365, where your filter drop-down isn't grouping date values correctly. This can be quite frustrating, especially when trying to create summaries efficiently. I am Raja Hunain, a professional with over 3 years of experience specializing in Excel and data management. My expertise extends to Visual Basic, Data Processing, Excel VBA, and more, making me well-equipped to resolve your filter issue swiftly. You can review my portfolio where I have tackled similar Excel-related challenges: https://www.freelancer.com/u/rajahunainweb I assure you a quick and clean fix to restore the normal year-based hierarchy in your filter, along with a brief note explaining the solution to prevent future occurrences. Thank you for your consideration. Regards, Raja Hunain
$10,50 USD em 7 dias
0,0
0,0

Hi There, I can quickly diagnose and fix the issue in your Excel 365 workbook so the date filter correctly groups values by Year > Month > Day, instead of listing each date individually. Since your column already contains true date values, I’ll focus on identifying what’s breaking the hierarchy (such as hidden formatting, mixed data types, table settings, or locale-related issues) and apply a clean, reliable fix. What I’ll do: Inspect the date column to confirm data types and underlying values Restore the normal Year/Month/Day grouping in the filter Ensure newly added dates behave consistently going forward Return the corrected workbook Provide a brief explanation of what caused the issue and how it was resolved This will allow you to summarize and filter dates efficiently without running into the same problem in future files. Once you share the workbook, I can apply the fix quickly and confirm a fast turnaround. Best regards, Annisa
$10 USD em 5 dias
0,0
0,0

Dallas, United States
Método de pagamento verificado
Membro desde abr. 21, 2021
$10-15 USD
₹750-1250 INR / hora
₹600-1500 INR
₹600-1500 INR
$250-750 USD
₹600-1500 INR
$15-25 USD / hora
₹1500-12500 INR
₹12500-37500 INR
$10-30 USD
₹12500-37500 INR
₹100-400 INR / hora
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
₹1500-12500 INR
$30-250 USD
$30-250 USD
$10-30 USD
$10-60 USD