Find Jobs
Hire Freelancers

Data extraction using dependent and independent lists in Excel

kr70-192 SEK

Closed
Posted over 8 years ago

kr70-192 SEK

Paid on delivery
Hi all, I am working on a project where I have created three dependent lists (A2:C2) and two independent lists (not variable from any previous input) for cells D2:E2. Check out the attachment for details. Under the sheet "Raw Data", I will have a massive amount of entries regarding the different options (as stated in the lists) and would like to count the entries that match the given values in my lists. Now here is my problem: I would like to be able to: 1) Count all entries when none of the fields are selected 2) Count all entries when A2 is selected - fields B2:C2 are clear 3) Count all of the entires in B2 when both A2 and B2 are selected - Field C2 is clear 3) Count all of the entries in C2 when the previous entries (A2 and B2) have been selected On top of that, I would want the independent lists (D2:E2) to be able to filter out entries, as well, during any given stage above. I have previously tried IF-statements, SUMPRODUCT, HLOOKUP and VLOOKUP in order to solve the equation but have not been successful. Is this even possible to solve using functions or would a VBA approach help? If so, what should I look into? Hope that the logic above makes sense and that somebody could provide an solution and/or explanation on how to attack the problem.
Project ID: 8013763

About the project

18 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average kr153 SEK for this job
User Avatar
A proposal has not yet been provided
kr163 SEK in 3 days
4.8 (204 reviews)
7.0
7.0
User Avatar
Hi, I've done formula regarding all 4 listed requirements based on field "Last log in" (blank/YES/NO). I am able to send it to you for review once you open chat with me. Best regards, Hoang
kr192 SEK in 0 day
5.0 (132 reviews)
6.8
6.8
User Avatar
Hello Sir, Im excel VBA macro and formula Expert :) i can do anything in excel , please give me your excel file i can help you to attack your problem :) Thank You Sincerely Prameswara :)
kr152 SEK in 0 day
4.9 (340 reviews)
7.0
7.0
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 240 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
kr160 SEK in 3 days
4.9 (129 reviews)
6.4
6.4
User Avatar
Hi! excel automation is my masterpiece and willing to help you and suggest what best for your project. Feel free to message me to start the project. Thank you.
kr150 SEK in 1 day
4.8 (72 reviews)
5.5
5.5
User Avatar
Hi, We are experts in excel based data processing. If you want to achoeve all the points together then a VBA macro behind is best option which whenever run will do the operations and will generate 5 reports based on your points. Kindly let us know if you want to discuss. However I would like to mention that the amount is very small for a VBA work. You may have to increase that. Regards, Pal
kr232 SEK in 2 days
4.9 (33 reviews)
5.1
5.1
User Avatar
Hello, I have years of extensive experience in Excel Automation & VBA programming & and expert in dealing with the tasks like the one mentioned by you in the problem description I should be able to assist you with this in a swift manner. We can connect over skype and discuss it further. Please do let me know in case you would like me to assist you. I would write custom VBA functions for you in the excel doc, which you can call withing your sheet to achieve the desired results. Please check my reviews for my most recent excel related projects, i am in the process of finishing two right now too :-) I am looking forward to hear back from you. Thanks and Regards, Abhinit
kr172 SEK in 1 day
4.9 (21 reviews)
4.5
4.5
User Avatar
Hi @@@@ lowest rate Lowest bidder Lets Start.... 100% job satisfaction.....payment after work.. Would you like to discuss more?
kr70 SEK in 1 day
4.6 (25 reviews)
4.7
4.7
User Avatar
A proposal has not yet been provided
kr163 SEK in 1 day
4.3 (4 reviews)
2.7
2.7
User Avatar
This seems to be a easy task if we can use vba rather than elaborate vlookup functions. Please let me know if you want me to hire so that we can discuss further.
kr212 SEK in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
Hello. My name is Henry. I'm very interested in doing this project, as I'm quite proficient in Excel and writing Excel VBA macros with proven experience for 10+ years. I'm looking forward in helping you with this project, and accept any reasonable budged that you might offer. I'm TOEFL-test and Microsoft Certified Professional certified and currently work as an IT Manager.
kr163 SEK in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. Here's what I understand of your requirement: - You would like to count the number of entries depending on the filters selected While it will be possible to achieve with functions, it will be a lot simpler to use VBA. In my experience, The only downside when using VBA vs. functions is that VBA is not able to run on its own without being initialised (i.e. real-time updating). However, this will not be an issue for you. I will add a description of what every line of VBA does so that you may modify it with ease. PS: I bidded low cas I am new to Freelancer and would like to gather good reviews.
kr100 SEK in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good 10 years of experience in vba with automating manual tasks for various process. Have written more than 500 macros for various data and source(database, web based, ticket rising tools, sharepoint, standadize templates etc..).
kr163 SEK in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I develop spreadsheets with VBA as part of my job for a well known FTSE 100 company in the UK. I realise my rating is not great on here, but to my defence I've been busy developing my second Android app. You brief seems not too difficult and I'm fairly confident I could complete it within a day. My most recent Excel task that was fairly similar to this was comparing two sheets of data and that involved over 220 million lookups. With your project I would use VBA it would be easier and quicker to use. I would use the worksheet selection change function that is available on each worksheet and open the relevant sheet and perform the count according to your conditions. Please let me know if you have any further questions. Thanks
kr192 SEK in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
pick me, youll have no regret, im new here, but im experienced for 5 year in coding, especially on excel and vba
kr70 SEK in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
一个有效的提议尚未被提供
kr132 SEK in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Uppsala, Sweden
4.9
5
Payment method verified
Member since Jul 28, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.