Search results

Hi , If you do not want to use a helper column , then select your entire data range and format the cells in one colour. Then , keeping the entire data range selected , add the following conditional formatting rule and select a different colour. =MOD(SUM(IF(FREQUENCY(C$2:C3,C$2:C3) >0, 1)), 2)...

Hi , Can you explain what your requirement is ? The formula you want adjusted depends on the formula in column L ; tracing the logic of your requirement based on multiple formulas is not as easy as developing the required formulas based on your requirement logic if you can explain that clearly...

Hi , In case you find Peter's solution somewhat overwhelming , see if this is OK. 1. In any unused column , say column D , enter the number 1 in the first row of data ; I have entered 1 in cell D3. 2. In cell D4 enter the following formula , and copy down. =IF(C4=C3, D3, -D3) 3. For the...

Hi , The following formula gives the same results : =IF(A2=A3,IF(D3<G2,D3-E2-1,G2-E2-1),G2-E2-1) Narayan

Hi , Give me some time ; I will check and come back to you. Narayan

Hi , Post links to those examples which have not worked , or post the code which does not work , or best of all upload your workbook with the data , the Data Model , Pivot Table(s) , Slicer(s) and code in it. Narayan

Hi , I will explain. Consider the following entries for one person. 140398 0.5556 Festival Leave 21-Apr-2019 21-Apr-2019 18-Apr-2019 22-Apr-2019 140398 1 Sick Leave 07-Aug-2019 07-Aug-2019 06-Aug-2019 08-Aug-2019 140398 1 Sick Leave 20-Aug-2019 20-Aug-2019 19-Aug-2019 24-Aug-2019...

Hi , Just to explain the logic , we can revise the formulas as follows : In the left-most column , we only look at the column itself and its right hand side neighbour. So the formula in the first cell becomes : =IF(AND(E3 > 0, F3 > 0), 1, 0) In every succeeding column , we look at the column...

Hi , But if you have a workbook with more data , please check thoroughly to ensure that it is correct. Narayan

Hi , See if the logic in the attached file is correct. Narayan

Hi , Give me some time ; I will try. Narayan

Hi , If you can upload a workbook which has much more data , say a thousand rows , it will help to test a formula thoroughly. Narayan

Hi , See if this is OK. Narayan

Hi , See the attached file. Test it out thoroughly. In case you do not wish to apply a criteria to any field , you can either leave it blank or select the Any option. Narayan

Hi , See the attached file. Narayan

Hi , Please upload a workbook with adequate data in it. Narayan

Hi , I have earlier said that the button which does not have any text on it is the RESET button ; clicking that button removes a filter. Is this your last request ? Please mention what all combinations are possible ; will there be only two combinations possible (e.g. A or B , A or C ,....) or...

Hi , But why would you want a value such as Overall which represents all the other values ? Filtering on all the values is as good as not applying a filter. Narayan

Hi , Please upload a workbook with adequate data which breaks the formula. Narayan

Hi , This is at an advanced level : https://chandoo.org/wp/kpi-charts-dashbaords/ Narayan

Hi , Continue with this : https://chandoo.org/wp/kpi-dashboard-revisited/ Narayan

Hi , Start with this : https://chandoo.org/wp/create-kpi-dashboards-excel-1/ Narayan

Hi , Having the data in separate tabs makes data extraction through formula much more difficult. VBA can help. If the data is together in one table , then data extraction is simple. The workbook you have uploaded does not contain the data validation lists ; can you include them and then...

Hi , Your requirement is not clear to me. With reference to the data which is present in Sheet2 , can you also post an output sheet which contains data after the second macro has operated on your input data in Sheet2 ? Narayan

Hi , I am not facing any problem at my end. The scrollbar is working properly. Narayan