© 2023 Hashnode
#spreadsheets
Ugh.., I have so many duplicate rows in my spreadsheet. Well so do many other people. With the script in this article, you can introduce a menu button that lets you delete duplicate rows in your sprea…
You use sheets a lot and sometimes have difficulty identifying duplicate rows. Then after this blog, you’ll be equipped with a script that’ll highlight duplicate rows in your sheet. Namaste! This is N…
Goto sheets.google.com - I saved this spreasheet as Temp. Now click on the Extensions > App Script in the top-level menu as shown here : Now, you'll see an editor like this below : Now enter this co…
Originally published for freeCodeCamp Spreadsheets are powerful and awesome. 💪 In this tutorial I will show you four ways to find the percentage difference between two numbers in Excel. I'll also sh…
Intro I am writing this short blog to share a solution to a problem that has been bugging me for a while, which is to find the last row in a column accurately. Problem Usually, when you use google app…
Originally published for freeCodeCamp In this article I will show you how to clear formatting from a cell in Excel. If you want the quick and dirty version, it's first up and will require you to simp…
📈 Spreadsheets and Goals I found it immensely helpful to create a spreadsheet outlining some of my goals this past year. I'll reference it throughout this article, and here's the link if you'd like t…
Welcome to the second part in this series. This isn't covering features of OpenPyXL directly. But since a lot of the data brought into Excel is from CSV files. I thought we should get this out of the …
Python is a general-purpose language that is capable of working on many different project types. People create web sites, games, data science, utilities and so much more. A common application for Pyth…
There seem to be millions of software development agencies and freelancers around the world these days. To stand out in this competition, you need to find a way to deliver to your clients faster. An efficient way to deliver features quickly…
