Realce.net

Coding, ML, tech musings and inspiration from Paris

Hello !

Welcome to Realce.net

If you're interested in coding, you'll find here why we code with enthusiasm, exploring creativity with P5js coding, the power of Machine Learning algorithms with python, as well as improving productivity with VBA, and much more.

Scroll below to find out more about our recent highlights!

Coding

The MaxIf function

2007, Jul 01

If you work with data in Excel, you probably already used the functions SUMIF and COUNTIF. In this post, we show how to extend it with the function MaxIf, a function written in VBA that can also be very useful.
This development example shows how VBA can help developing a custom set of function for data analysis.

tags: VBA Excel productivity

Coding

What is VBA ?

2007, Jun 12

A few words describing the language called VBA that can help you automate some repetitive or tricky tasks in particular in Excel. Also it's a great way to start coding

tags: code VBA Excel

1
2