Spreadsheet Tips (4): Use Excel to Write Excel Formula
In my previous article, I share some tips on how to use Excel to write FoxPro SQL coding (" FoxPro Tips (1): Use Excel to Write Your Codes "); in this article, I will share another tip of using Excel to write coding - but this time is for writing formula in Excel spreadsheet itself! You may find out some tedious formula can actually be written in a very quick & simple way. Let me share with you real case study. One of the exercises I have completed with my client recently was checking Prophet model point files ("MPF") produced from a new tool - to find out if there are any differences from the existing MPF: STEP 1: Import MPF into Excel Figure 1: New MPF data (labeled as "data1") Figure 2: Existing MPF data (labeled as "data2") To compare new and existing MPF, import the MPF into Excel (note: MPF are in comma delimited format) and organize the data as per Figure 1 & 2 below. If you examine "data1" sheet and ...