Dear sir,
I can make your macro in 1 hour, 40$.
I’m very very specialized in excel formulas and teaching. I have made hard exercises for people that need advanced understanding of
- Complex multi-condition Index/match formulas
- Formulas in pivot tables, in number formats, in graph axis colors, in conditional formatting, and in dropdown menus.
- Size reduction for big data files
- Time reduction for files with too many calculations
- efficiency shortcuts (98% of times, I don’t even touch the mouse in Excel)
1- Experience Excel : since 2004 both VBA and Formulas. I can make very complex formulas with multi conditions and text search applied on big ranges of data.
Example a formula to find the minimum value in column A, when a specific text exists in column B, other conditions in column C, and make operations on it in a single cell.
I know VBA, Java, C++, Python, JavaScript. In 2008 I was already working on a program of 70 000 lines of code in C++ that calculated the braking distance of A320 airplanes.
2- Academics : I graduated a Master in computer science and mechanical engineering from the top French Engineering school and this can be publicly verified.