Combining and filtering cells
$10-60 USD / hour
Hi. In short, I need to see what COMBINATION of procedures are being paid by difference insurance companies. The problem is that each procedure code is in a different row, and you also just can't filter for the same person or code because the two or three codes being assessed must be from the same day. So you can have the person's name or codes come up 5 or 6 times, but on different dates. What I've done so far was filter out the paid column by using an IF statement (if > 0 paid, if 0 not paid). I then created a pivot table where I separated the procedures codes into column of paid and not paid and filtered the person to "count if" names and created a separate row to filter out greater than 2 procedures because excel doesn't let you filter a pivot table and I need to see combination of procedures, not just each individual. However, this isn't entirely accurate because the count if could have been on different dates. Also, I can't then compare to the insurances being paid to have meaningful easy data as data sets I will be working with range from 100k-200k rows. I need help with the set up to be able to apply this to different data.
Project ID: #33836172
About the project
33 freelancers are bidding on average $31/hour for this job
Greetings! Thanks for the detailed requirements. I think we can achieve the desired results using formulas alone without Pivot Tables. Can you please share a sample of the dataset? I can come up with required formulas More
Hi there, We can get on a call and figure out the problem better with some examples. Once I understand the complete problem statement, I can give you an effort estimation. Let me know if you would like to get on a ca More
Hi I can work on the project and can start work right now. I have 15+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust to me. Result will be as you need Best Regards
I have good experience in power queries and formulas in excel. Can you please let me know some sample data. Thanks.
Hi, I will be able to finish this work in 30 min. even less. I am a new registered freelancer. However, I specialize in Excel and VBA/Macro in Excel, Word, and Outlook with 20 years' experience. I will perform any tas More
Hello , Great to connect with you! Hope you doing great despite your requirements. I have gone through your requirement and understood every aspect of them related to your need. I look forward to serve you. I have work More
Hi prospective client, I have read all of your requirements. Your project can be completed using VBA or Power Query (or Excel formula if desired). I strongly believe that your project can be completed within a couple More
I am a data analyst with thorough understanding of Microsoft office packages, eviews and stata. I am a research fellow with good level of meticulousness to ensure that your project gets the best results. From the pro More
Hi there, my name is Itoro Koffi, and I can offer you a solution to your challenge by using Power Bi to create a data model to properly visualize your rows of Data.
I can able to process your data through my skills efficiently and provide you with great results. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible.
Hi, Im Mark Glenn. I graduated Bachelor of Science in Accountancy. After graduation, I worked as a Sales and Service Associate in Philippine National Bank for 4 and a half years. As a bank employee my task was to valid More
hello, I can do it because I have done a job similar to what you want, please take a look at my profile, and we can chat to discuss and explain the detainees via message in freelancar, thank you.
Hi there. I'm ready to start the task right now. I will utilize my years of expertise to carve your data to meet your requirements. Please send me a message for discussion. I can assist with creating and editing the da More
Hi, I would like to work in such type of tasks so would be keen to work with you in said project . Atleast we can communicate on it if feel attractive you can go ahead with me thanks and regards
Hi there, I am able to work on it and provide better solutions for what you are looking for. Thanks for considering me on this job, I work with excel in a daily basis and will be work to deliver it within agreed deadli More