I have a spreadsheet in ods format.
The goal is to compare two numbers against each other, that are within 5.
i.e 5 and 9
i.e 5 and 10
not 5 and 11
The issue is that the data changes, so need a formula that will be consistent, when the data changes.
I've uploaded two examples with different formulas, you can use it and build your own.
Both examples are not perfect, but I need it to be perfect.
The position of the cells must not change only the formulas.
Hi! I can do what you need both in OpenOffice and MSExcel quite easily. All you need is a review of the "match" formula. Waiting for your contact if you want any more information. Relevant Skills and Experience Stron Daha Fazla
16 freelancers are bidding on average $23 for this job
Hi, I am good at Excel and formulas in open office. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Daha Fazla
Hello Sir, I m Maulika from India having superior experience in Data entry. Expert in excel with high speed. I can make it done asap.
Dear I have go through your project requirement in detail and willing to do it as per your requirements by applying advanced excel formulas. Best regards Humayoon Relevant Skills and Experience Excel
I have done similar projects & confident to assist you. I'll take responsibility to complete the work accurately & on time. You can trust my work and award this project to start from now. Thanks Relevant Skills and Ex Daha Fazla
Hey,I'm VA and Web Researcher. I'm Really interested in this [url removed, login to view] you need accurate work in low rate,you can knock [url removed, login to view] keep faith on my words Waiting for your massage Regards,Towfiq Relevant Skills and Experience Daha Fazla
$20 per work Habilidades y experiencia relevante excel teacher work Htos propuestos $20 USD - done