Find Jobs
Hire Freelancers

Fix Spreadsheet Blank Rows Issue

£10-20 GBP

Fermé
Publié il y a 2 mois

£10-20 GBP

Payé lors de la livraison
I'm currently facing a perplexing challenge with a spreadsheet function (fx) that I've created, which extends over approximately 140 rows. The primary objective is to have this function smoothly generate results for each row without any hiccups. However, despite the function operating flawlessly as I drag it down from row 2 to row 140, it mysteriously returns completely empty cells in 20 specific, non-changing rows. The data manipulated by this function mainly comprises numbers. The issue is in col AA spreadsheet "ForeCast" **Ideal Skills and Experience:** - Proficient in Excel or similar spreadsheet software - Strong understanding of functions/formulas, particularly with text manipulation - Ability to troubleshoot and resolve issues related to cell functions - Experience in handling and interpreting spreadsheet data accurately **Requirements:** - Analyze the spreadsheet to determine the cause of the blank cells in the fixed positions. - Propose and implement a solution to ensure that all rows display the intended output from the formula without any blanks. - Ensure the correction does not negatively impact the rest of the spreadsheet’s functionality. - Document any changes made for future reference. The perfect candidate for this job would be someone who can work efficiently to diagnose and correct this puzzling issue. Experience in fixing similar problems and a keen eye for detail are critical. Your expertise will help maintain the integrity of the data manipulation functions within the spreadsheet and ensure seamless performance across all rows.
N° de projet : 37778886

Concernant le projet

62 propositions
Projet à distance
Actif à il y a 1 mois

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
62 freelances proposent en moyenne £17 GBP pour ce travail
Avatar de l'utilisateur
Hi, this is definitely possible. The problem i saw immediately you have "Thur" instead of "Thu". I am looking to see if any other problems occur. Let me know if you are interested, i am available right now. Thanks, Milan
£10 GBP en 1 jour
5,0 (808 commentaires)
7,6
7,6
Avatar de l'utilisateur
"""""""""""""""""""ADVANCE EXCEL EXPERT/FIX SPREADSHEET"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
£20 GBP en 1 jour
4,9 (288 commentaires)
7,4
7,4
Avatar de l'utilisateur
Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 years of in the Freelancing field. With my skills and expertise, I can guarantee 100% success rate in your project. I have a deep understanding of the requirements of this project and I'm confident that I can provide you with the best results. Additionally, I provide regular updates during the project so that you don't have to worry about anything. Please feel free to contact me if you have any questions or would like to discuss this opportunity further. All the best, Muhammad Ali
£19 GBP en 1 jour
5,0 (170 commentaires)
6,8
6,8
Avatar de l'utilisateur
Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
£20 GBP en 3 jours
4,9 (153 commentaires)
6,2
6,2
Avatar de l'utilisateur
With over 20 years of experience as an IT Project Manager and developer, I’m confident in my abilities to troubleshoot and resolve issues like yours. My impressive skills with Excel and proficiency in Visual Basic allow me to quickly analyze spreadsheets, identify problems, and implement effective solutions. This means I'll be able to analyze your formula in col AA spreadsheet "ForeCast," detect where the error lies, and fix it promptly. My experiences have deepened my understanding of data manipulation. As an avid problem solver, my first step would be examining your function lines for any irregularities or miscalculations across the 140 rows in consideration. Upon detection of the root cause causing blank cells in those 20 fixed positions, I'll provide a documented solution that won't impact the rest of the spreadsheet's functionality neg
£15 GBP en 7 jours
4,9 (34 commentaires)
5,4
5,4
Avatar de l'utilisateur
Dear Client, I have sound knowledge of Power BI. Also, I previously carried out several projects in Power BI using DAX. I ensure you will be happy after hiring me. Kindly contact me. Check my portfolio, Main Profile - https://www.freelancer.com/u/mhgroup21 Thank you
£30 GBP en 1 jour
5,0 (46 commentaires)
5,2
5,2
Avatar de l'utilisateur
I understand that the results letter in coloum AA depends on day of coloum B. I checked the function error in coloum AA and able to fix it and give correct results for all rows. I'm available to work on it right now About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION
£15 GBP en 1 jour
5,0 (30 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hi there, I am J K Nuwan. I have read your project description and I am ready to assist you with this task. The project is very clear to me. I'm ready to start the project now. Looking forward to hearing from you. Thank you J K Nuwan
£20 GBP en 7 jours
4,8 (58 commentaires)
4,7
4,7
Avatar de l'utilisateur
To address the perplexing issue of the spreadsheet function in column AA, which fails to produce results for 20 specific rows out of 140, I propose a systematic and efficient approach rooted in my expertise with Excel and spreadsheet functions. My strategy is designed to diagnose, correct, and future-proof the spreadsheet against similar issues, ensuring seamless functionality across all rows. I will conduct a thorough check to ensure data consistency across all rows, particularly those affected. This involves addressing any discrepancies in data formatting or hidden characters that might be influencing the formula's performance. Based on my findings, I will adjust the formula to accommodate any anomalies or exceptions identified, refining its logic to prevent blank results. To minimize the risk of similar issues arising in the future, I will provide a set of best practices and guidelines focused on maintaining spreadsheet integrity and ensuring consistent data handling. As a seasoned professional with a history of resolving complex spreadsheet issues, I am confident in my ability to restore the full functionality of your spreadsheet, ensuring that all rows accurately produce the intended results. My approach not only aims to solve the current problem but also to enhance the spreadsheet's overall robustness against future challenges.
£20 GBP en 1 jour
4,9 (14 commentaires)
4,3
4,3
Avatar de l'utilisateur
I've been working with Excel for over 4 years now, and have faced several intriguing challenges similar to yours in that span. My expertise lies in data processing, which is quite relevant to your project. I have a proven ability to analyze spreadsheet functions and come up with tailored solutions that don't compromise functionality. One aspect I pride myself in is my keen eye for detail, which has often come in handy when handling large sets of data like yours. This means not only being able to troubleshoot and fix the specific issue at hand but also ensuring that other formulas don’t get affected in the process. As someone who values the integrity of my work, I always ensure thorough documentation of any changes made, which could prove helpful in future reference and prevents repetition of any glitches like this one. My approach to projects is driven by an out-of-the-box thinking strategy. I constantly look for innovative ways to solve problems, saving both time and resources while delivering quality work. If you choose my services, you can expect a freelancer who's always willing to go the extra mile to meet and exceed client expectations. I'm excited to take on this specific challenge as it aligns perfectly with my skill set and will be thrilled to resolve it for you efficiently.
£15 GBP en 1 jour
4,8 (7 commentaires)
3,7
3,7
Avatar de l'utilisateur
Hello. Looked into your attached file and I soon found the issue. If you award this project to me, I will solve it immediately. Regards, Katie.
£20 GBP en 1 jour
5,0 (3 commentaires)
3,1
3,1
Avatar de l'utilisateur
As an expert in Excel and data processing, I am well-equipped to tackle your challenging spreadsheet issue. Having spent years working and solving complex problems using spreadsheets, I have developed an analytical and troubleshoot-oriented mindset that suits your needs perfectly. My expertise extends to deciphering and fixing formula-related problems swiftly, making me a strong candidate for resolving your mysterious blank cell issue in col AA of the 'Forecast' sheet. My experience with data manipulation, especially when dealing with large data sets as your project requires, will be immensely beneficial throughout the entire process. I understand the importance of maintaining data integrity and minimizing any negative impacts on the rest of the spreadsheet's functionality, which are both crucial objectives that I aim to fulfill. Additionally, my meticulous nature ensures that not only will I fix the problem at hand, but I will also document any changes made accurately for your future reference. Moreover, my dedication to delivering high-quality work is unparalleled. I promise to resolve this issue promptly without sacrificing accuracy or reliability. Rest assured that once we start working together, I'll be available round-the-clock for any support you may need. Let me help you get rid of the perplexity in your spreadsheet and ensure seamless performance across all 140 rows.
£10 GBP en 1 jour
5,0 (3 commentaires)
2,8
2,8
Avatar de l'utilisateur
Dedicated Freelancer Ready to Elevate Your Project for Fix Spreadsheet Blank Rows Issue. I have a solid background in Data Processing, Excel, Data Entry and Visual Basic, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
£10 GBP en 1 jour
5,0 (1 commentaire)
2,8
2,8
Avatar de l'utilisateur
Hi there, I am an experience excel professional, I can solve this problem and deliver the project to you in an Hour or less. Please reach out. I will work on this right away.
£20 GBP en 1 jour
5,0 (4 commentaires)
2,6
2,6
Avatar de l'utilisateur
Hello, I have checked the attached Excel file, I found where is the problem. Would you mind contacting me in chat so I can tell you what is the cause of the empty cells (it is an easy minor thing .... you do not have to pay for anything). Best regards.
£10 GBP en 1 jour
5,0 (7 commentaires)
2,8
2,8
Avatar de l'utilisateur
Hi good day. I saw that you are in need of help. I am Hazel with 2 years of experience in Data Analyst. I am hoping that you will be choose me and help you with this project. If you will choose me, I will be able give the data to you accurately and with a good turnaround time. Hoping to hear from you soon.
£30 GBP en 3 jours
5,0 (1 commentaire)
2,8
2,8
Avatar de l'utilisateur
Hello, I understand the importance of resolving the issue with the function in the "ForeCast" column. I have extensive experience with Excel and spreadsheet troubleshooting. I will thoroughly analyze the spreadsheet, identify the root cause of the blank cells in the fixed positions, and implement a solution that ensures all rows display the intended output without any blanks. My approach prioritizes accuracy and maintains the overall functionality of the spreadsheet. I'm ready to start working on this challenge and will provide clear documentation for any changes made. Let's get your spreadsheet running smoothly across all rows. Best regards, Mohamed
£20 GBP en 1 jour
5,0 (2 commentaires)
2,0
2,0
Avatar de l'utilisateur
Hello, I have a lot experience I can be the best for your project. After I checked your excel file there were several errors in writing the formula, such as 'thu' and 'thur’. I can start working now. My typing speed is 55+ WPM with 100% accuracy. I have an experience of more than 5+ years of Data Entry in Government Departments. I will do this project without any mistakes. You can trust me. Please give me a chance so that I can show you my skills and tell you about my hard work. Thank you for considering me. I would welcome the opportunity to further discuss how my skills and experience. Regards, Erina
£11 GBP en 1 jour
5,0 (2 commentaires)
2,0
2,0
Avatar de l'utilisateur
With over a decade of experience, I, Asad Ur, am not only an Excel and data maestro but also a problem-solving virtuoso who excels at quickly identifying and rectifying mysterious spreadsheet glitches much like the puzzling one you're encountering. I've often found that such issues are rarely isolated incidents; they often have larger implications within the dataset. My unique blend of problem-solving expertise will ensure that not only do I promptly identify why the blank cells toggle specifically in those 20 rows but also fixes them without compromising any other aspects of your spreadsheet's functionality. In addition to my proficiency in Excel, which includes experience with functions and formulas, I am also well-versed in VBA – this will help me troubleshoot your issue from multiple angles to provide an accurate solution. Furthermore, as a meticulous person and a perfectionist by nature, it's embedded in me to pay careful attention to detail while ensuring data integrity. As part of my commitment to quality work that satisfies my clients' needs perfectly, I will gladly document the changes made for your future reference. To summarize, my passion for transforming raw information into actionable insights combined with diverse technical skills encompassing Excel and VBA mastery positions me perfectly to fix this perplexing issue for you. Together, let's unravel the hidden stories of your data and ensure your "ForeCast" column sings with accurate figures in all 140 rows!
£10 GBP en 1 jour
5,0 (4 commentaires)
1,9
1,9
Avatar de l'utilisateur
As a seasoned Excel professional, I possess a wealth of experience handling complex spreadsheet functions and troubleshooting issues - just like the one you're facing. From my understanding of your problem, the cells in col AA within those 20 positions inexplicably returning blank needs a meticulous investigation to identify any factors influencing this behavior. I assure you that I have both the analytical skills and the ability to deploy appropriate fixes without disturbing the rest of your data. Moreover, my career as an accountant has endowed me with exceptional numerical abilities suitable for handling data manipulations involving numbers, such as yours. My firm grasp on formulas and text manipulation will ensure that each and every row displays the intended output from the formula without any blanks. Even more importantly, I value documentation greatly, which means I will provide you with all relevant details regarding any changes made for future reference. In conclusion, hiring me would offer great value to this project. My rich background in Excel along with my unwavering eye for detail and robust problem-solving abilities are precisely what you need to conquer this perplexing challenge. Let's get your spreadsheet performing seamlessly across all 140 rows!
£20 GBP en 1 jour
5,0 (1 commentaire)
1,5
1,5

À propos du client

Drapeau de UNITED KINGDOM
London, United Kingdom
0,0
0
Méthode de paiement vérifiée
Membre depuis janv. 10, 2024

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.