Tagged: excel
Excel lookup master list to find missing or found records
Something like below will help in finding a value in a master list and report if the input is missing or found in the master list. Sample =IF(ISNA(MATCH(C2,A2:A15,0)), “Missing”, “Found”) Format =IF(ISNA(MATCH(value,array,0)), “Missing”, “Found”) References Related posts: Excel –...
Can’t connect Excel to Hive using ODBC driver on MAC
So you done everything right and can’t connect Excel to Hive using ODBC driver on your macOS? Let’s see what is going on. Are you running El Capitan on Sierra? Well I was running Sierra and tried connecting before while...
Excel – generate random sample data file
Some formulas that will help you build sample data files Random number generation =RANDBETWEEN(1,1500) Generates random number between 1 and 1500 Random text generation =CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65)) Generates random text of 3 characters Related posts: Smart Pointers (Modern C++)