Amit SardaFeb 16, 20192 minGuessing Genders using Google SheetsIf you have a list of names and you want to guess their genders, here’s a nifty utility developed in Google Sheets that you will find handy.
Amit SardaFeb 13, 20192 minAutomatic Calculations in Google SheetsMany a time, you will have additional columns in your datasheet, running calculations based on the raw data being imported.
Amit SardaFeb 12, 20192 minSplitting a List into Multiple ListsHow to split a spreadsheet into different spreadsheets based on a column in the spreadsheet?
Amit SardaOct 5, 20181 minGenerating m*n (and more) Combinations using TableauProblem Statement Generate all possible m*n (and more) combinations of codes for Product Range, Items, Cover Variations, Fabric options. ...
Amit SardaSep 28, 20182 minData Transformation using Excel and TableauData transformation is fun! More so when you’re doing it using tools like Microsoft Excel and Tableau. While programming languages like P...
Amit SardaMar 27, 20181 minCounting Unique Values in a ListProblem and Dataset I recently had a client who wanted a quick way to count the number of unique values in a list. In the following case,...
