Table of Contents In this article we will learn how to filter cells having bold font formatting in excel using a simple VBA code Steps to insert code Open the Visual Basic Editor using Alt + F11 Goto Insert Tab Click on Module Paste the below code into module Code Using the function Create a…
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 What is Power Query ? Power query is a combination of various features of Excel and VBA. It has user friendly interface to perform the day to day functions. It can not only perform VLOOKUP of Excel but also automate the same by generating a code, on its own, in ‘M’ language….
Table of Contents Example We have Region, Product and Year wise sales in a excel sheet. Now, we need to create multiple excel sheets containing year wise and region wise sales for each product. Steps Create a pivot table: Select the data range, Go to Insert Tab –> Pivot Table –> OkKeep Region in Rows, Year in…
Table of Contents What is Merge Query ? Merge query is a feature of power query which helps us to get data from multiple files based on one or multiple common columns. Merge query works in similar fashion as VLOOKUP in excel but we can do a lot more using this feature. VLOOKUP in excel means Vertical lookup….
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…
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…
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…
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…
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…