Features

Table of Contents Example Consider this dataset containing a mix of alphabets and numbers, now I want to ignore all the text and fetch only the numbers or vice-a-versa, I may want to ignore all the numbers and fetch only the text. For this there is no ready-made formula in excel. Though we can use…

Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables.  Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2)  Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…