Recent content by srinidhi

Hope this helps

You need to insert a pivot table and then the slicer for it. Please post the full data to help you out.

Hope this helps, full automated with Tables for data, Pivot for summary & slicer for date selection.

Hi, Kindly use the table on data if you have large dataset and updating frequently, Assuming there is a unique loan number, a pivot table is best suited for such cases. You can group the dates as quarters, and apply to the pivot table. Veh No Sum of Pinciple Sum of Interest A...

Hi, Your formulae is taking Jan to Jan as 1 year, that's why its showing the 1st year amount. Just changed the date to 31st Dec 2021, its showing correctly.

used =XLOOKUP(A2,status!C:C,status!B:B) , if you have office 365.

Hi, Have put table on the unsorted data and pivot from the table, you can use the pivot or you can VLOOKUP from the pivot to your desired sheet. Just refresh the pivot to get the newly added data.

Vlookup will get you the required results

Hi Excel Experts, I work with large data sets in excel and very frequently apply the Vlookup formula. In the Vlookup formula there is an parameter called Col_Index_num, where we key in the result column number. ex: Columns A:F, we key in as 6 , as need the result from F Column, this range...

The solution I can think of is to extract the numbers from the text & concatenate them, concatenate the criteria as well, A Single Vlookup with give you the answer.

Hi, Right click on the column, format cell and select numbers, hope this solves your problem.

Hi, I also face a similar situation in my work, I just apply the text to column and again concatenate on the relevant column(I sort on the last relevant column and then concatenate , like in your data the pain area is the Street No. and Name and the City. concatenate : 4515 North Silver...

Hi, The weight and size needs to be under the parcel size so e.g. 4L and 4kg will fit within the second tier of $6.54 / $9.74. Even though 4L is under 12L, the weight pushes it into the next bracket. You are just looking at the L & not the weight, weight 4 Kg is above 3kg & below 5 Kg...

Hi, I guess the best & the easier way is to apply Pivot table & use slicers for filtering. I have just shown a sample in the attached file. Kindly ref sheet2. The slicers can be rearranged & customized.

HI, PFA the file, hope this is what you are looking for, if works on nested ifs. I have just added for JAN & FEB, please continue for rest of the months. In data you need to enter the data.