I need a function for an excell worksheet that takes the data from a string containing several bytes and calculates the sum of all bytes.
The number of bytes may vary.
The Sum must be in hexadecimal;
The return must be in hexdecimal;
The string contains spaces as shown below:
01 30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE 27 04
The sum cannot count either the first byte or the last two Bytes, given the example above:
It will be disregarded from the sum:
What will be sum
30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE
The last two bytes of the sum will be disregarded.
Function Return = 06 27
Hello, I would like to work on your project. I have great experience using excel macros / vba, formulas. I intend to do this task using a short custom vba code, within a macro enabled file, it can be made either as a u Mai multe
10 freelanceri licitează în medie 23$ pentru acest proiect
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Mai multe
Hello. I've read your project details. I am very familiar to Excel. And I can finish this in 1 hour. Let's discuss details over chat. Thank you.
Hello!! Am very interested in ur project and I'm an expert in Word/Excel/Excel Marcos/VBA/Visual basic/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
Hello Sir/Madam, My name is FATIMA and writing is my passion “When I say work, I only mean writing. Everything else is just an odd job”. From my early age, I enjoyed reading novels and stories, as I was growing up it Mai multe
Hello, I am expart of exel. Like Microsoft exel. So I can complete your project normaly. So you can give me this projects to complete. I am new. Thank you.
Soy experto en Excel Relevant Skills and Experience He realizado varios proyectos en Excel solucionando problemas que de otra manera tomaba horas de trabajo a solo minutos, solo con Excel