Hi Suman You can try using a PivotTable You will need to sort your data by Code/Date/Time. You will then need to add a helper column to get t...
Hi Juliana Please attach what you have done so far for us to understand better your needs. Sunny
Hi Mariya Just set the cmbPart Combobox MatchRequired to FALSE You will need to do this for all your other combo boxes. Hope this helps Su...
Since you only want to count cells with a 0 (excluding blank cells and cells with text) then in cell B2 of the Statistics sheet, enter =COUNT('1:15...
Hi Mirjam COUNTIFS(A:A;A3;B:B;2018) Count the number of each Supplier in 2018 COUNTIFS(A:A;A3) Count the number of each Supplier irrespective of...
Hi AbuElia As long as your worksheets formats are consistent, you can use 3-D referencing. To create a formula with a 3-D reference in the argum...
Here is the macro version. Please note that I have hard-coded the ranges. You will need to change it if it is different. Hope this helps Sunn...
Hi Melinda Your attachment did not contain the CF so no idea if you set it up correctly. You can refer my attachment to see if it meet your need...
Hi Mirjam Give this a try. Sunny
Hi Mariya I will use a different method for this. I am assuming you want a physical prefix with leading zeroes and not formatting the cell. Refe...
Hi Mariya You can refer attached for an example. I am finding the maximum value in column A and then add 1 to it. This will give the next seq...
Hi Paul Another formula (there can also be many other methods) is =SUM(OFFSET(INDIRECT(ADDRESS(ROW(),MATCH($BL$1,$2:$2,0))),0,0,1,20))*100 Ju...
Hi Mariya Give this a try. I have added a Combobox9_Change() event that will then fill Combobox8 with the required data. I have disabled your...
Hi David Thanks for your kind and flattering comments. Learning is a two-way process. While I give my two-cents worth of ideas (useful or otherw...
Hi Saliha You cannot edit data in a PT. You can either add a helper column in your source data and divide it there or you can create a calculate...