Find Jobs
Hire Freelancers

Formula to count data - Excel

$10-30 AUD

Ukończony
Opublikowano prawie 3 lata temu

$10-30 AUD

Płatne przy odbiorze
Hi All, I have a spreadsheet which includes large sets of data, showing an account and the person responsible (managers) for it across many months. We wish to show some reporting on the number of accounts and managers. For each month i need to count the number of accounts/managers which have a value greater than $0.00, and show those which are added. Whilst my spreadsheet is very large and doing this manually is very time consuming, i am hoping to use a formula to work this out for me. Once an account is new, it will have a positive balance, and have not previously had an account value. When we add new accounts we add a row. So a new account is active when the row goes from $0. 00 to any amount above this (as money have been invested now). So for this month a new fund has been added. Sometimes we have people who already have accounts with us, but set up another one. So for example if we have a new account have funds invested (goes from 0 to anything above) we have a new account, and if the "Manager" isn't on our list (column B), we count this as a new "Manager". So if we have a new account and manager invest, we count this as a new manager and fund for that month. Then to show if a manager is new, the logic would be if the fund is new, and the "Manager" named in the row had no other accounts previously (eg any rows in the previous months with a balance above $0.). I believe this will show the new funds/managers in their respective months as they come in. My data comes from external spreadsheets, which cannot be altered, so the formula needs to be in the cells which show each month, and cannot use helpers cells. If anyone has any ideas on how to do this, it would be very much appreciated. I have included some sample data and workings. Many thanks,
Identyfikator projektu: 30536614

Informację o projekcie

40 ofert
Zdalny projekt
Aktywny 3 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
$0 AUD w 1 dzień
5,0 (322 opinii)
6,6
6,6
40 freelancerzy składają oferty o średniej wysokości $27 AUD dla tej pracy
Awatar Użytkownika
Hi, I am well versed with Excel formulas and automation in Excel and keen to work on this. It would help to have a quick discussion. Looking forward to your response. Thanks
$30 AUD w 1 dzień
4,9 (157 opinii)
6,6
6,6
Awatar Użytkownika
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$30 AUD w 1 dzień
4,9 (75 opinii)
5,7
5,7
Awatar Użytkownika
Senior Excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$20 AUD w 1 dzień
4,8 (120 opinii)
5,4
5,4
Awatar Użytkownika
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I WOULD DO EASILY ALL COUNT. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Excel Solver, Advance dynamic charts, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
$15 AUD w 1 dzień
5,0 (49 opinii)
4,9
4,9
Awatar Użytkownika
Hi, Greetings! ✅checked your project details. I can build excel formula. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have Power BI and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high. Please Ping me the chat box for further discussion Thank You
$25 AUD w 1 dzień
5,0 (29 opinii)
4,5
4,5
Awatar Użytkownika
Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love the perfection of work. You can see an example of one of those project in my portfolio here: https://www.freelancer.com/u/Monirulop If you are interested to work with me message me, waiting for your message. Thanks! and be safe, Monirul
$30 AUD w 1 dzień
4,9 (23 opinii)
4,0
4,0
Awatar Użytkownika
I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response. Let me know the more details the project. <Is>
$15 AUD w 1 dzień
4,6 (7 opinii)
2,2
2,2
Awatar Użytkownika
Dear Employer, This is a interasting project you have, i have done many similler projects recently and looking forward to discuss more details. I can start the work right now, also i am open for unlimited revisions. You can check my profile for more details and feel free to contact me anytime. Thanks
$10 AUD w 7 dni
5,0 (3 opinii)
2,0
2,0
Awatar Użytkownika
Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call me a "Prince of Excel". I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!
$30 AUD w 1 dzień
5,0 (2 opinii)
1,7
1,7
Awatar Użytkownika
Hello Sir, I am ready to do the task as per described condition. If I am hired for this project I will be give it my full attention and deliver on time. Apart from this, I possess all the skills that you have outlined and can effectively work towards tight deadlines. I'm ready to start right now and will finish ASAP. Let's discuss for more. Thank You Md. Nazimul Hasan
$20 AUD w 7 dni
5,0 (3 opinii)
1,6
1,6
Awatar Użytkownika
Hello, I have read your project description and interested. I can give you tergeted valid list. I will complete your task manually 100% accurate. So come to chat section to discuss more about your project for quality work. I'm waiting for your response. Thanks Topper Team
$20 AUD w 1 dzień
5,0 (2 opinii)
1,3
1,3
Awatar Użytkownika
I am an expertise on Data entry and excel, also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors.
$20 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I am a professional graphics designer and data entry expert. I have 14+ years of experience. I have worked on graphic design in different companies for 12/13 years and finally I am freelancing. I am expert in Adobe Photoshop, Adobe Illustrator, Microsoft Word, Microsoft Excel, Background Removed, Clipping Path, Image Editing, Logo Design, Business Card Design, Banner Design, Data Entry, Video Editing etc. I work on various marketplaces like Up work, Fiver, Freelancer.com etc. Actually Graphics design is my passion. I will work until your satisfaction. I have design the based on your requirement so please check & let me know if you need any changes. I would try my best for you and i am graphics Design Trainer. will be delivered in (AI,eps,JPG,PNG,PSD, Pdf etc file). My Services : 1. Logo Design 2. Banner Design 3. Business Cards and Stationary 4. Background Removed 5. Clipping Path 6. Image Editing 7. Photo Editing 8. Data Entry 9. Branding 10. Flyers 11. Poster 12. Brochure 13. leaflet 14. Photoshop editing and image retouching 15. Illustrator Task (Freestyle, realistic, Etc) 16. Poster 17. Brochure 18. Flyer 19. Book Layout 20. Illustration 21. eBook/ Book Cover, Album cover 22. Graphic T-shirt design and much much more Thanks and regards, Md. Amzad Hossain Tarek
$20 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Excel skills to consider listing on your resume include: Capturing and recording important data. Using shortcuts and formula functions. Building charts and graphs. Sorting and filtering data. Utilizing pivot tables. Detail each Excel skill you possess. List experience with Excel using clear examples.
$20 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I have knowledge of excel very well. I Can sort the data in different ways. Sort number wise,manager wise,monthly or according to invest amount.
$30 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
hi, I am Excel expert. I can help you setup a formula for automation purposes. We can have a chat in chat box. Regards Lalit K
$15 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I will do this in time by given days or with 2or 3 days in short time , as you wish
$20 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello sir/madam, I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you by my quality services. I am ready to unlimited feedback of your any requirements. Thank You
$20 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello , I will give my best and in shortest time your work will be completed , if you will allow me to do your work
$30 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I have read your job description and I understand to do this job. I have five years of experience in this industry. I will do your job 100% perfectly without any mistakes If you give me this job I will give you the best result & outputs. I have skills and I familiar with many technologies. So give me this job without any confusion. I hope you give me this job. If you give me this job I do it honestly & hardly. I want to make a long-term good relationship with you. So you can give me this job without any confusion. I am waiting for your reply. Thank you.
$15 AUD w 1 dzień
4,8 (2 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
caulfield east, Australia
5,0
6
Zweryfikowana metoda płatności
Członek od cze 5, 2019

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.