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
10 freelancer đang chào giá trung bình $23 cho công việc này
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, 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