Excel on Circular References

What is a Circular Reference & why use them? A circular reference is created when you refer to same cell Read More …

Change the row color based on a cell’s value (Excel)

Say, you have a table of your company orders like this: You may want to shade the rows in different Read More …

Equazioni dimensionali

L’analisi dimensionale è uno strumento concettuale applicato frequentemente in metrologia, fisica, chimica e ingegneria per comprendere le situazioni fisiche che Read More …

Excel – Ignore formula errors with VBA code

To remove the annoying error flags (with a green triangle in the corner and an exclamation point with a drop-down Read More …