Category: excel
Excel spreadsheets can be protected using password, for example, example excel with password protection. Open this, and any modification or viewing the VBA script/macro requires unprotecting the sheet first. …
Most people requires mortgage to purchase a house (property). You borrow money from the bank and promise to pay back (with interests) within a specified periods e.g. 25 years. …
Microsoft Excel is a powerful spreadsheet that you can put values, strings, and even formulas in each cells. The following are four useful/important functions regarding to cells in Excel. …
Excel Column to Number Given a column title as appear in an Excel sheet, return its corresponding column number. For example: A - 1 B - 2 C - …
September 15, 2014
beginner, case study, code, code library, excel, implementation, programming languages, string, VBA, vbscript, windows scripting host
In this article, I am going to share a easy and quick way to delete some duplicate rows (e.g. regarding column B) from a spreadsheet but the requirement is …