I have 2 excel files, a file from 2018 and a file from 2019. The files are invoice lists for different companies, about 20,000 total rows for each year. For example, Company A might have 15 different rows (of unique invoice number) on the 2018 sheet but NONE on the 2019 sheet Company B might have 80 rows (of unique invoice numbers) on the 2018 sheet but only 10 on the 2019 sheet. I need an output that would show:
Company Name 2018 2019
A 15 0
B 80 10
Bu iş için 88 freelancer ortalamada $86 teklif veriyor
so you need count of those file invoives in diff sheet? i understood, all i need is spreadsheet, and i will have this done for you thanks.......!
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have a list in Excel that will retrieve the total number of invoices per Company from Daha Fazla
Hello, I’m an Excel expert and I would like to help you with your report. I'm fully available and I can start right away. Please check my profile and contact me to discuss further details. Regards.
Hello, I can help to scale maximum rows of unique invoice number per company for 2018 and 2019. I’m ready to start immediately. Please drop a PM if you’re interested. Best regards, Hoang
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Daha Fazla
Hello. I am a visual basic programmer, I have written many program for excel. I will write some code for this, which I can give you after. A simple program to read and count the invoices of each company. I can have it Daha Fazla
Hello Sir/Madam, It is my pleasure to be able to bid on your project. Right now i will start working on your project. Really very much interested to have this project, if you permit. Please check my reviews for bet Daha Fazla
hello there! I have read the project description and its an easy task with a simple solution. I can complete it in a few hours with much low price than you have actually suggested for the work. Hope to chat with you Daha Fazla
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro co Daha Fazla
Hi.. If you provide me the your excel file.. it'll be better to understand the exact project requirement. I have experience working on excel. so, if you provide excel file.. i'll provide you sample work before start wo Daha Fazla
Hi, I can develop macro to create report as per your example. Company Name 2018 2019 A 15 0 B 80 10 Macro will extract data from 2018 and 2019 sheets according to company name or invoice number or whatever you use as Daha Fazla
Hello, I can construct an Excel macro file that will allow you to select file paths for each file through file picker. Then you can press a button that generates the result as requested. You won't need to specify file Daha Fazla
Hi, dear! I've a lot of experience of jobs with MS Excel with VBA. Please give me chance to work with you. Ping me to discuss about your project. Thank you.