Find Jobs
Hire Freelancers

Macro for excel who finds data

$30-250 USD

Cerrado
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
hello, I'd like to create a specific macro for excel My database on excel will look like that and shouldn't be bigger than 1000 entries A1 : 50 x ; 25 y ; 10 z = 85 T A2 : 26 X ; 22 y ; 5 z = 53 T A3 : 12 x ; 23 y ; 4z = 39 T A4 : 80 x ; 29 y ; 36 z = 145 T ….. …… A853 : 150 x ; 22 y ; 25 z = 197 T Etc… from this base I want to make the following search : get all the scheme who gives for example : 2 x ; 48 y ; 14 z = 124 T as a result, here for example it's A1+A3 but if A43+A2 works too I want it in the results too, I want ALL the possible schemes.
ID del proyecto: 6072582

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
27 freelancers están ofertando un promedio de $80 USD por este trabajo
Avatar del usuario
I have a question after that I can code the macro. Ready to start. Thanks ******************************************
$64 USD en 3 días
4,9 (281 comentarios)
7,7
7,7
Avatar del usuario
A proposal has not yet been provided
$147 USD en 3 días
5,0 (206 comentarios)
7,4
7,4
Avatar del usuario
A proposal has not yet been provided
$83 USD en 1 día
4,9 (255 comentarios)
7,6
7,6
Avatar del usuario
Hi there. I have read the description and I would be able to retrieve all the possible combinations that produce the same result. Kindly discuss before awarding the project. Regards. Usman.
$90 USD en 1 día
5,0 (77 comentarios)
7,1
7,1
Avatar del usuario
Hello, I can do it with macro + excel function. Macro for finding all matches of X works, Only to choose from this list those entries matching Y and Z using excel function (max 2 hours). Best regards
$60 USD en 1 día
5,0 (139 comentarios)
6,8
6,8
Avatar del usuario
Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom
$77 USD en 3 días
4,9 (34 comentarios)
5,2
5,2
Avatar del usuario
HI I am an excel-vba expert and I can help you with your project pm me ........................................................................................
$155 USD en 3 días
5,0 (37 comentarios)
5,3
5,3
Avatar del usuario
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC. I am available now and would aim to finish in 2 days Please contact with more detail. I need to know if more than 2 cells can be added to get the required result A1 : 50 x ; 25 y ; 10 z = 85 T A2 : 26 X ; 22 y ; 5 z = 53 T A3 : 12 x ; 23 y ; 4z = 39 T A4 : 80 x ; 29 y ; 36 z = 145 T 142 X ; 76 y ; 51z = 283 T would be A1+A2+A4 and I would need to know the range for the numeric data ie 1 to 999 or 1 to 9999 Regards David
$80 USD en 3 días
4,9 (36 comentarios)
5,2
5,2
Avatar del usuario
Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel database and VBA on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with Microsoft databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Excel and Visual basic to develop all types of requirements related ,and given my experience, i am persuaded to give you to give High quality of work delivery withing budget and time Best regards,
$54 USD en 2 días
5,0 (7 comentarios)
4,8
4,8
Avatar del usuario
Hello, if processing time is not a problem, this is a fact of product/comparision problem. Not too hard to implement. If you are interested, we can talk further and maybe do some kind of demonstration. Feel free to contact me for further questions. Thanks for reading!
$155 USD en 3 días
4,9 (3 comentarios)
3,0
3,0
Avatar del usuario
Hello, I'm VBA expert with many years of experience. I can quickly create a VBA code for you that will go through all data (even more than 1000) and send back all matching rows. I have done similar tasks in past, so please check my ratings to see that I'm more than skilled to do this task. If you have any questions, please contact me. Thank you Dusan
$70 USD en 2 días
5,0 (6 comentarios)
1,9
1,9
Avatar del usuario
Hello Sir, I would like to work for you on this project. Pls contact and give more information about the work and others. Looking forward for your reply.
$70 USD en 3 días
4,5 (4 comentarios)
1,6
1,6
Avatar del usuario
Hi, Creating the macro in Excel would be feasible, but I want to propose you a better solution. I can provide you a desktop tool ( Windows ) that will read the Excel file, accepts user input, calculates and then present all the possible schemes in a tabular form. A button will also be added so that you can export the result (all possible schemes ) to Excel file. Please let me know should you have more concerns regarding the features of the tool. Kind regards, ryugarai27
$88 USD en 1 día
5,0 (1 comentario)
1,5
1,5
Avatar del usuario
Hi there Just wrote a script that'll find and list the working sums. It works, job done, and you can have it right away. I can pretty it up and make userforms and that. Wont take long either. This is assuming, that you only want to find fx A1+A3. Not if A4+A5+A230 works. Or A3-A45. It can be done though. Just takes a bit longer. Regards, Ove
$30 USD en 0 día
5,0 (1 comentario)
1,3
1,3
Avatar del usuario
A proposal has not yet been provided
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, what you need is: get all combinations of rows according to your final equation entered (only sum right?). Can be N matches. No problem, it will be easy. Contact and get it on the deadline. Gmail: mejiagarciaj **** Hola, lo que necesitas es: obtener todas las combinaciones de filas segun tu ecuación final ingresada (solo suma verdad?). Pueden ser N coincidencias. No hay problema, será sencillo. Contáctame y lo tendrás en el plazo mencionado. Gmail: mejiagarciaj
$66 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Create a parameter tab with a button to do the action and get results on either a results tab or on the same parameter tab the requirements needs to be clarified to get to the desired results.
$100 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Employer, i want to work with you. i have performed all of the duties listed in your job description. give me your work and see my work quality,
$100 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I'm an Excel developer with 24 years experience and this job appears to be a good fit for my skill set. I did have one clarifying question though: Are you only interested in locating 1+1...pairs...of records that match your criteria? Or do you want to find triples? quadruples?...etc? ...ALL possible schemes? If the later, that will take longer to develop and execute. Please let me know and thank you for your consideration.
$88 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hi, As I am using EXCEL for calculation techniques in various field with Macro & similar type of functions, i damned sure about successful completion of project.
$35 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AFGHANISTAN
Kabul, Afghanistan
0,0
0
Miembro desde jun 15, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.