Subject Line You don’t need a helper for lookup all the time Overview Sometimes you may need to get the output without using helper column. What is a helper column? We create a separate column and concatenate both the values in a separate column and then use it as a lookup value to get the
Working Let’s understand with the working help of the example below (Table1: Sales Report) Table 1: Sales Report We have 2 Tab’s for conditional formatting i.e. Conditional_Formatting_1 & Conditional_Formatting_2 Figure 1.1 Conditional_Formatting_1 Figure 1.2 Conditional_Formatting_2 Let’s apply conditional formatting on the below table (Conditional_Formatting_1 tab) Step 1: Select the data(D2:H13) Step 2: Go to
Working Let’s understand how we can link one slicer to 2 Pivot tables based on different data sources with the help of an example. We have 2 Tables one is Sales table and other is the Lead Table. We also have a Product table where we have only Product which are available in Sales table
Subject Line How to automate the pivot table in different reports? Overview As we know Pivot tables are used to Summarize, Sort, Reorganize, and Group, Count, Total or Average data. But sometimes we many need to make copies of the pivot table for each unique item in a field. This will help us to save lot of time
Subject Line 2 way lookup is amazing Overview Sometimes you may want to lookup a value in a table using both rows and columns. You can build your own formula that to perform a two-way lookup with help of INDEX and MATCH function. Syntax =INDEX(data,MATCH(val,rows,0),MATCH(val,columns,0)) Let’s understand both the function INDEX function returns a value in
