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…